This tutorial demonstrates how to remove autofilters in Excel and Google Sheets.
Say you have the data range shown below filtered by Month (Column D).
As you can see, only rows with Feb-21 in Column D are filtered for and displayed while Rows 3–9 are hidden.
As a result, all filters are removed, and all rows from the data range (B2:G16) are now displayed.
Remove Filters in Google Sheets
To remove filters in Google Sheets, go to Data > Turn off filter in the Menu.
As in Excel, all rows are displayed after turning off the filter.