Excel Study · Module 2: Entering & formatting data
Class 19Filter data
Basics1:13 videoFree
Click a cell in your list and choose Data → Filter: a button appears on every header. Open one, untick Select All, tick what you want, and OK — the other rows are hidden, not deleted (the row numbers jump).
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, my data in A1:C7 is filtered. Write a formula for C9 that adds up only the visible Sales in C2:C7.
The answer that works
✓ checked in Excel=SUBTOTAL(109,C2:C7)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.