Filter by numbers, then sort what shows
Show the invoices over an amount, sort them from the ▾ on a heading, and turn the filter off again. Intermediate · 4 min · Number filter, Sort from the heading, Filter off
Ticking values suits a column with a few different entries. For amounts, where nearly every value is different, you want a range instead: everything from 1,000 up.
The ▾ on a column of numbers has two boxes for that, Numbers from and to. Fill in one for a lower or an upper limit, or both for a range.
The same ▾ can also sort by its column, so you rarely need to leave the table: filter down to what matters, then put it in order.
In Excel, the range is under Number Filters in the ▾: Greater Than Or Equal To, Between and the rest.
Steps
Click a cell in the table, such as
A2, and turn on Filter.Show only the large invoices. Open the ▾ on Amount, type 1000 in Numbers from, and click OK.
Put them in order without leaving the table. Open the ▾ on Amount again and click Largest first.
Done with the filter? Click Filter in the toolbar again to turn it off.
Remember
- For numbers, filter by a range: from, to, or both.
- The ▾ on a heading also sorts by that column.
- Clicking Filter again turns it off and shows every row.
- Hidden rows still count in formulas like
SUM.
Previous: Filter a table · Next: Turn a range into a table