Sort and filter
- Click a cell in the data, then use Sort A to Z or Z to A to sort by that column.
- Use Custom Sort to sort by several columns in the Sort by / Then by dialog.
- Click Filter, or press Ctrl+Shift+L, to add AutoFilter dropdown arrows to the headers.
- Click a header arrow and tick or untick values, or type into the search box, to filter rows.
- The panel is grouped into sorting commands, filters such as by colour, above or below average and Top 10, and the value checklist with its search box; confirm with OK.
- Use Clear to remove the filter and show all rows again.
Tip In a filter search box, prefix a number with >, >=, < or <= for a numeric filter.