Sort & Filter
- Data › Sort and Filter
- Toolbar
Puts your rows in order, or hides the ones you are not interested in. Both work on the range you have selected, so take in the header row.
- Click a cell inside the data, taking in the header row.
- Click Sort & Filter: the button opens a menu, it does not sort on its own; the arrow that appears on a column letter opens the same menu, after moving the active cell into that column.
- Choose Sort A to Z or Sort Z to A to order the rows by the column you are in, or Custom Sort… to order on several columns at once.
- Choose Filter to put the ▾ arrows on the header cells, then narrow the rows from an arrow.
- Use Clear to drop the criteria and show every row again, and Reapply after you change the data.
- Entries that cannot do anything are greyed out: Clear stays unavailable until a filter is really applied.
Tip Select the whole table, never a single column: ordering one column on its own pulls it out of step with the rows beside it.