Select the filtered range or click anywhere in the table
Go to the Data tab
Click Clear in the Sort & Filter group
Or click the filter drop-down arrow in a column
Choose Clear Filter From [Column Name]
To remove all filters, turn off Filter on the Data tab
If using a table, click the filter arrow and select Clear Filter From All Columns as needed
