Course / Sort and filter

Filter a table

Show only the rows you want by ticking values, combine filters on two columns, and bring everything back. Beginner · 4 min · Filter, Tick list, Hidden rows

A filter hides the rows you don't want to see right now. Nothing is deleted and nothing moves: the rows are still there, and they come back the moment you clear the filter.

Turn it on, and a ▾ appears on every heading. Each one opens a list of that column's values with a tick beside each: untick what you don't want.

Two things tell you a filter is hiding rows: the ▾ on that heading turns into a funnel, and the row numbers turn blue and skip, such as 3, 7, 8.

In Excel, these are on the Data tab: Sort A to Z, Sort Z to A, Sort and Filter. The shortcut is Ctrl+Shift+L.

Steps

  1. Click any cell in the table, such as A2, then Filter in the toolbar.

  2. Show only the North region. Click the ▾ on Region, untick (Select all), tick North, and click OK.

  3. Filters on different columns work together. Keep North, and on Product show only Chair and Shelf.

  4. Bring every row back, but leave the filter on. Open the ▾ on each heading that shows a funnel and click Clear.

Remember

Previous: Sort by two columns · Next: Filter by numbers, then sort what shows