Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to extend the filter range in Google Sheets.
How To Extend Filter Range In Google Sheets
When filtering data in a Google Sheets spreadsheet, by default only the visible data is filtered. This means that if you have a filter applied to your data, and you hide a row or column, that data will still be filtered.
If you want to filter all of the data in your sheet, regardless of hidden rows or columns, you can extend the filter range. This will make sure that all of your data is filtered, even if it is not currently visible.
New data added after a filter is applied to a table may also not be included in the actual filtered range.
In this guide, we will show you how to extend the filter range in Google Sheets.
How to Expand the Current Filter Range in Google Sheets
Here’s how to Expand the Current Filter Range in Google Sheets.
First, select the filtered range you want to extend.
In this example, the cell range E1:E21 has a filter applied. We want to extend this range to include cell E22:E26 as well.
Click on the Filter icon in the toolbar to remove the filter from the selected range.
Ensure that the range you want to filter is selected. Click on the Filter icon a second time to re-apply the filter on the range.
The range should now be extended to include the indicated cells.
In this example, we were able to use the filter to arrange the column in alphabetical order. Notice how the new cells, indicated in blue, are affected by the filter.
This guide should be everything you need to extend the filter range in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to filter in Google Sheets:
- Create Multiple Filters
- Create A Filter
- Create A Filter View
- How To Filter
- How To Create & Use Filter Views
- Filter By Multiple Conditions
- Filter By Color
- Filter Not Working (How To Fix)
- Filter Unique Values
- Filter by Date Range
- Filter Duplicates
- Filter Google Sheets Only For Me
- Filter Charts Using Slicer