← Using a Computer, in Practice
Spreadsheets · 56 of 111
Filter a list to see only what you need
Expert guidance
Do this
- Click in your table, or select it.
- LibreOffice Calc: Data, AutoFilter. Google Sheets: Data, Create a filter.
- Click the small arrow on a column heading.
- Choose only the value you want, such as “Grade 9”.
- To see everything again, turn the filter off the same way.
Why this way
The other rows are still there, just hidden. You can tell, because row numbers jump and the arrow changes color. In a shared Google Sheet, others see your filter too, says its help page, and those who can edit can change it. Expert guidance.
Do it today
Make a list of ten classmates with their houses or sections, and filter for one. Five minutes.
Where these facts come from
- Applying AutoFilter, LibreOffice Help.
- Sort & filter your data, Google Docs Editors Help.
General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.
