How to Create Filters in Google Sheets

  • MORE

Google Sheets can contain multitudes of data, so much so that you'll need help organizing it. To that end, you can use the Filter tool to temporarily remove rows, based on what you need to show at the moment, so you don't need to delete information.

filter end 557271

Also, filter gives you options to help you organize columns alphabetically and by highest to lowest or lowest to highest. Here are our step-by-step instructions for using Filter in Google sheets.

MORE: Best Chromebooks Available Now

How to Filter in Google Sheets

1. Highlight cells you want to filter and sort.filter01

2. Click the filter button.filter02

3. Click the triangle button at the top of a column.filter03

4. Uncheck an item to filter the line it's on from the chart. This does not delete the line, it only hides it.filter04

5. Click OK.filter05

6. Click Z->A to sort the rows from greatest to least based on the contents of this column. Conversely, click A->Z to sort the rows from greatest to least based on the contents of this column. If you select Filter by condition, you can create rules that will instruct the Sheet to automatically filter out rows that contain certain results.filter06

How to Save a Filtered View

If you save your filtered view, you can return to it later after you've made other views or reset the rows.  

1. Click the triangle next to the Filter button.filter2 1

2. Click Save as filter view.filter2 2

3. Enter a name.filter2 3

4. Click X.filter2 4

You've filtered a Google Sheet and saved a filtered view.

filter end

Author Bio
Henry T. Casey
Henry T. Casey,
After graduating from Bard College a B.A. in Literature, Henry T. Casey worked in publishing and product development at Rizzoli and The Metropolitan Museum of Art, respectively. Henry joined Tom's Guide and LAPTOP having written for The Content Strategist, Tech Radar and Patek Philippe International Magazine. He divides his free time between going to live concerts, listening to too many podcasts, and mastering his cold brew coffee process. Content rules everything around him.
Henry T. Casey, on
Add a comment