How do I...
Filter my data
What to do
- Click any cell in your data.
- Go to Data, then Filter. Ctrl+Shift+L does the same thing.
- Click the arrow in a heading.
- Tick what you want to see and click OK.
Good to know
- Filtering hides rows and does not delete them.
- Use Clear on the Data tab to show everything again.
- To add up only what is showing, use SUBTOTAL.
The idea in general
It hides what you do not need, so you can focus on one part of a long list.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.