See all How-To Articles

How to Remove Filters in Excel & Google Sheets

In this tutorial, you will learn how to remove data filters in Excel and Google Sheets.

 

remove filters excel initial data

 

Remove Filters

Say you have the data range shown below filtered by Month (Column D).

 

remove filters excel initial data

 

As you can see, only rows with Feb-21 in Column D are filtered and displayed while Rows 3–9 are hidden.

To remove all filters and display all rows, in the Ribbon, go to Home > Sort & Filter > Filter (or use the keyboard shortcut CTRL + SHIFT + L).

 

remove filters excel

 

As a result, all filters are removed, and all rows from the data range (B2:G16) are now displayed.

 

remove filters excel final data

 

Remove Filters in Google Sheets

To remove filters in Google Sheets, go to Data > Turn off filter in the Menu.

 

google sheets remove filters

 

As in Excel, all rows are displayed after turning off the filter.