You can sort by color to group the highlighted cells at the top. In the screenshot below, the names of the students to be emailed have been highlighted. To sort by cell color in your Excel file, right ...

How to Include All Rows for Filters in Excel. Microsoft Excel helps you sort your data for analysis by providing a Filter command. ... when you want to sort number values from low to high, ...