Filter a Data Table

Show only the rows you care about with AutoFilter.

You will learn to

• Turn on filters
• Filter by a value

How it works

Select your data and choose Data → Filter. Drop-down arrows appear in the header row; pick the values you want to see. Filtering hides rows without deleting them.