How do I filter rows in Google Sheets?

Create a filter (computer):

1. Select a range, then click Data > Create a filter (or right-click and choose Create a filter).
2. Click the Filter icon at the top of a column.
3. Pick one:
4. Filter by condition: choose a condition or enter a custom formula.
5. Filter by values: uncheck values to hide them, then click OK.
6. Filter by color: choose a text or fill color.
7. Search: type to find values.

Shortcut: right-click a cell and choose Filter by cell value.

Remove it: click Data > Remove filter.

Who sees it: a regular filter is visible to anyone with access to the file, and anyone with edit permission can change it. To keep your own view, use a filter view: click Data > Create filter view, sort and filter, click Save View, then Save. Open it later with Data > Change view. Only one view can be applied at a time.

If you only have view access, you can still create a temporary filter view that only you see and that is not saved.

In ProfitDrawer workbooks the column titles sit in row 7 of the Income, Expenses and Mileage tabs, so start the filter range at that row.