Show only the rows you need.
Use a filter to narrow a list without deleting the other rows.
A smaller view can answer a clearer question.
A list of supplies may contain Packed and Needed items together. If you want to see only what still needs attention, a filter can hide the other rows temporarily. The underlying records remain in the sheet.
Create two columns, Item and Status, with Cable/Packed, Notebook/Needed, and Pen/Needed. Select the table including its headers and choose Data → Create a filter. Open the filter control in Status and keep only Needed selected.
A temporary view
Cable · Packed Notebook · Needed Pen · Needed
Notebook · Needed Pen · Needed
Hidden does not mean removed.
Your view should now show Notebook and Pen. Cable still exists; clearing the filter brings it back. This distinction is useful whenever a list seems to have lost rows. Check the filter state before assuming data was deleted.
On a shared spreadsheet, an ordinary filter can affect other people’s view. Practice in your own scratch sheet. When working with others, learn the separate filter-view feature before changing the group’s view. The exercise here only needs a private copy.
Item Status Cable Packed Notebook Needed Pen Needed
Make it yours.
- Create the sample table and turn on a filter.
- Show only Needed in the Status column.
- Clear the filter and confirm all three items return.
What changed when you tried it?
A little nudge
Include the header row when selecting the table.
What to look for
Two items appear while Needed is selected. Clearing the filter restores the Cable row without recreating it.
Take it one small step further
Filter for Packed instead, then clear the filter again.
A filter changes the view, not the existence of the rows.
Read more: Google Sheets · Sort and filter ↗
No submission needed. This one is just for you.