Sort and filter
Updated November 13, 2026
Sort
- Click a cell in a column and choose Data › A to Z or Z to A.
- For more than one column, choose Data › Sort…, add a level for each column, and pick the order. Then choose OK.
Filter
- Click in your data and choose Data › Filter (Ctrl+Shift+L). Each heading gets a filter button.
- Choose a button to sort, search, or tick the values to show. You can also filter by numbers, dates or text.
- Data › Clear shows every row again. Reapply filters again after the data changes.
Tips
- Tables have filter buttons already. See Format a range as a table.
- Home › Sort & Filter has the same commands.