In Google Sheets sorting can help you work with specific data. In Google Sheets filtering can help you see only what you want to see.
To create a filter:
In our example, we'll apply a filter to an equipment log worksheet to display only the laptops and projectors that are available for checkout. In order for sorting to work correctly, your worksheet should include a header row, which is used to identify the name of each column. We will freeze the header row so the header labels will not be included in the filter.
- Click View and hover the mouse over Freeze. Select 1 row from the menu that appears.
- Click any cell that contains data.
- Click the Filter button.
- A drop-down arrow appears in each column header.
- Click the drop-down arrow for the column you want to filter. In our example, we will filter column B to view only certain types of equipment.
- Click Clear to remove all of the checks.
- Select the data you want to filter, then click OK. In this example, we will check Laptop and Projector to view only these types of equipment.
- The data will be filtered, temporarily hiding any content that doesn't match the criteria. In our example, only laptops and projectors are visible.
Applying multiple filters
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. In this example, we've already filtered our worksheet to show laptops and projectors, and we'd like to narrow it down further to only show laptops and projectors that were checked out in August.
- Click the drop-down arrow for the column you want to filter. In this example, we will add a filter to column D to view information by date.
- Check or uncheck the boxes depending on the data you want to filter, then click OK. In our example, we'll uncheck everything except for August.
- The new filter will be applied. In our example, the worksheet is now filtered to show only laptops and projectors that were checked out in August.
If you're collaborating with others on a sheet, you can create a filter view. Creating a filter view allows you to filter data without affecting other people's view of the data; it only affects your own view. It also allows you to name views and save multiple views. You can create a filter view by clicking the drop-down arrow next to the Filter button.
To clear all filters:
- Click the Filter button, and the spreadsheet will return to its original appearance.
- Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
- Select the Equipment Log tab if it is not already open.
- Freeze row 1.
- Sort the spreadsheet by the Checked Out date from most recent to the oldest.
Hint: Sort by column D from Z to A.
- Sort the range A2:F9 by column B from A to Z.
Hint: Make sure the box next to data has header row is left unchecked.
- Filter the spreadsheet so it only shows equipment that has never been checked in.
Hint: Filter column E to show cells that are empty.
- When you're finished, your spreadsheet should look like this: