Skip to content

← Using a Computer, in Practice

Spreadsheets · 56 of 111

Filter a list to see only what you need

Expert guidance

Do this

  1. Click in your table, or select it.
  2. LibreOffice Calc: Data, AutoFilter. Google Sheets: Data, Create a filter.
  3. Click the small arrow on a column heading.
  4. Choose only the value you want, such as “Grade 9”.
  5. 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

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.

← All 111 things to do