> FILTER TABLE ENTRIES

Hide data you don’t need so you can focus

Filters let you analyze your data by displaying only those data that meet criteria you specify. In our budget spreadsheet, we can filter out table entries where we were under budget so we can focus on those where we overspent.

To do this, select the table, choose Organize > Filter. Click Add a Filter. Choose Difference. With Numbers selected as the rule, choose “is less than” and type “0”.

The table and charts in the spreadsheet will now ignore all the entries where you were under budget and display the rest.