How to Filter in Google Sheets: A Step-by-Step Guide

Let's be real, sorting through data on a spreadsheet can be overwhelming. But don't worry, with Google Sheets, you can filter your data in a jiffy. Whether you're a seasoned pro or just getting started, I've got you covered with this step-by-step guide on how to filter in Google Sheets.

Step 1: Select Your Data

Firstly, you need to select your data. This could be a single column, a range of columns, or even the entire sheet, depending on what data you want to filter. Simply click and drag the mouse over the area to select it.

Step 2: Click on the 'Data' Menu

Once you have your data selected, go to the 'Data' menu at the top of your screen. Click on it and then select 'Filter' from the drop-down menu.

Step 3: Choose Your Filter Criteria

Once you've selected 'Filter' from the menu, you'll see a little filter icon appear next to each column header in your selected data range. Click on the icon to open up the filter menu.

From here, you can choose what criteria you want to filter. You can select specific values, sort from A-Z or Z-A, or even filter by color. You can also select 'Filter by Condition' to apply more advanced filters, such as filtering for values greater than or less than a certain number.

Step 4: Apply Your Filter

Once you've selected your filter criteria, click 'OK' to apply the filter. Your data will now show only the records that meet the filter criteria you selected. A drop-down menu will appear on each column with filters applied, letting you know what filters are active on that column.

Step 5: Edit or Remove the Filter

If you need to edit or remove the filter, simply click the filter icon on the column header and select 'Filter by condition.' You'll then have the ability to edit or remove the filter criteria. If you want to remove the filter entirely, just click 'Remove' from the same menu.

Step 6: Save and Reuse Your Filter

If you're happy with your filter and want to save it for future use, simply click 'Data' in the menu again and select 'Filter views.' From here, you can create a new filter view with your custom filter settings, give it a name and save it. You can also make changes to your saved filter view, apply or remove it à la carte for a specific sheet, or delete it entirely.

Pro-Tip: Not sure which filters to use? Try filtering by color to locate and group values that meet a condition that you defined. You can use conditional formatting to color-code certain cells and filter by color to view cells of a certain color only. This can help you quickly locate trends and patterns in your data, particularly in large data sets. It's like a power-up for your spreadsheet skills.


Filtering in Google Sheets is incredibly easy and can take your data analysis to the next level. It's a great way to speed up your work, make more productive use of your time, and make your data easier to understand. I hope this guide has been helpful. Happy filtering!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.