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

  1. Click in your data and choose Data › Filter (Ctrl+Shift+L). Each heading gets a filter button.
  2. Choose a button to sort, search, or tick the values to show. You can also filter by numbers, dates or text.
  3. Data › Clear shows every row again. Reapply filters again after the data changes.

Tips

Was this article helpful?