Topics/Tables, Pivots, Formatting and Data Tools

Table Filters

Premiumadvanced 15 min4 tasks0/54 pts

A filter adds a dropdown to every header so you can hide rows that do not match. Hidden rows are not deleted, just tucked away. Click inside a table and press Ctrl+Shift+L (or use Filter in the Data tools bar), then open a column's ▼ menu and untick the values you do not want.

Common mistakes

Selecting only one column before turning on the filter, so other columns do not filter with it.
Forgetting a filter is on and wondering why rows are "missing".

Excel Tables and Structured References Pivot Tables 1