Yes. In Excel for Microsoft 365 on Windows, click a cell in the table, then choose Data > Clear in the Sort & Filter group. This clears the table’s active filter criteria and reveals its rows without deleting the table or its data.
What clearing filters does in an Excel table
An Excel table can have filters applied in one or several column headers. A filter limits which rows are displayed; it does not erase the rows that are hidden. For example, if a sales table is filtered to show only the East region and orders over $500, the other records remain in the table but are temporarily out of view.
Using Data > Clear removes the active filter criteria for the current data range or table, so its rows are displayed again. It does not remove the table’s header row, formatting, formulas, or filter dropdown buttons. You can filter the table again afterward.
One important distinction: Excel’s Clear command can also clear sort settings for the current range. It is useful when you want a clean, unfiltered view, but it is not a way to restore a previous row order. Sorting changes the order of records in the worksheet; clearing a sort setting does not necessarily put them back where they were before. If the original order matters, keep a sequence or ID column that lets you sort back to it.
How to clear every filter from a table
Use this method when you want to see all rows in one table and remove the filters currently applied to it:
- Click any cell inside the table you want to unfilter. This helps Excel apply the command to the intended data range.
- Open the Data tab on the ribbon.
- In the Sort & Filter group, select Clear.
- Check the table’s rows and headers. The filter dropdowns should remain, but the active criteria should be cleared and the previously hidden rows should appear.
If the table has a filter applied in more than one column, Clear removes those criteria together. For instance, filters on both Region and Order Date are cleared in the same operation; you do not need to open each header dropdown in turn.
On Excel for Mac, use the Data tab and its Clear command as well. Ribbon layout and group placement can differ by window size and version, so look for Clear in the sorting and filtering controls. If you are unsure which table is affected, click inside it first and confirm the result before working with another range.
Clear one column’s filter instead
Sometimes you want to remove a single restriction but keep the others. In that case, use the dropdown in the relevant table header rather than the worksheet-wide Clear command:
- Select the filter dropdown in the column you want to change.
- Choose Clear Filter From followed by the column name, or select the option that removes that column’s filter.
The exact wording can vary with the kind of filter. A text filter might have options such as clearing a filter from the selected text column, while a date or number column can show its own filter choices. Removing the Region filter while leaving a Date filter active, for example, shows records from every region but still only within the dates selected.
This per-column approach is safer when the other criteria are intentional. If you want the whole table to show all records, use Data > Clear instead, then confirm that no other column still has an active filter.
Clearing filters is not the same as turning them off
Clearing a filter removes its selected conditions while leaving the filter controls available. Turning filtering off removes or hides the dropdown controls. For a table, those controls are part of the table’s header behavior; the Filter Button setting on the Table Design tab can show or hide them. Hiding the buttons is not the clearest way to reset criteria, so use Data > Clear when the goal is to reveal all rows.
On Windows, Ctrl+Shift+L toggles AutoFilter controls for a selected range. It is a toggle, not a dedicated command to clear all criteria, and its effect is different from choosing Clear. If your goal is simply to see every record, use the ribbon command rather than relying on this shortcut. Mac keyboard shortcuts can differ by Excel version and keyboard settings; the ribbon command is the dependable option.
Filtering is also different from sorting. A filter hides rows that do not match conditions, whereas a sort rearranges records according to values in one or more columns. Clearing filter criteria makes hidden rows visible. It should not be treated as an undo for a sort or as a command to recover the table’s previous sequence.
Check that the table is really unfiltered
After clearing, scan the headers and the visible row numbers. A filter dropdown may show a funnel symbol when criteria are active; ordinary filter arrows can remain even when nothing is filtered. Also check whether the table’s row count looks plausible. A blank-looking area or a missing category can make it seem as if a filter remains when the records are simply farther down the sheet.
Tables can also be filtered by controls other than their header dropdowns. For example, a slicer connected to the table can continue limiting what is displayed. Use the slicer’s Clear Filter button, typically shown as a filter icon with a red X, to remove its selection. If several slicers are connected, clear each one that is restricting the table.
Another useful check is to inspect the filter menus on columns that have been used before. If the table still shows fewer records than expected after Data > Clear, make sure you cleared the intended table and not a different range. Then look for slicers, hidden rows, or a second table on the sheet that may be causing confusion.
Common problems and how to solve them
- Clear is unavailable or has no visible effect: Click a cell inside the filtered table and check again. If the worksheet is protected, the command or filtering actions may be restricted; use the appropriate worksheet permissions or ask the workbook owner to unprotect it.
- Some records are still missing: Check each header for active criteria, then inspect connected slicers. Also check whether rows were hidden manually. A filter reset does not necessarily unhide rows that someone hid separately.
- The table’s order changed: Clear is not an undo command for sorting. If the table has a stable record number or date-and-sequence field, sort by that field to restore the intended order. Without a saved ordering key, the former order may not be recoverable just by clearing.
- The buttons disappeared: Filtering may have been turned off rather than cleared. For a table, select it and check the Filter Button option on Table Design. Turning the buttons back on restores the controls, but use Clear to remove active criteria.
- A total or formula does not match the visible rows: Some formulas respond to filtered or hidden rows differently from others. For example, SUBTOTAL is designed to calculate over filtered lists, while a regular SUM can include values in rows that are hidden by a filter. Review the formula’s purpose rather than assuming the table data was deleted.
Keep useful table features while resetting the view
After clearing filters, the table remains a table. Its structured columns, formatting, header controls, and calculated-column behavior are not removed by the Clear command. This is why clearing is usually preferable to copying the visible cells into a new range when you only want to reset what is displayed.
For a shared workbook, it helps to distinguish the data from the view. A filter is a viewing choice, not a deletion. Before clearing criteria in a workbook used by colleagues, consider whether they are relying on the current view. If preserving a particular analysis matters, note the criteria or save a separate copy before changing the view.
For recurring work, a stable ID column is useful when records may be sorted. A separate note or saved set of instructions can also make multi-column criteria easier to recreate. These habits do not change how Clear works, but they help prevent the common mistake of assuming that the command can restore a prior sort or remember a filter setup.
Frequently Asked Questions
Does Clear All Filters delete rows from an Excel table?
No. It removes filter criteria and displays rows that were hidden by those criteria. It does not delete the records or table formatting.
How do I clear filters in only one table column?
Open that column’s header dropdown and choose its Clear Filter From option. Other column filters can remain in place.
Why are filter arrows still visible after I clear filters?
The arrows are controls, not proof that a filter is active. Clear removes criteria but normally leaves the table’s filter buttons available.
Does clearing filters undo a sort?
No. Clear can remove sort settings, but it does not reliably restore the previous row order. Use a saved ID or sequence column to sort records back into the desired order.
Why are some rows still missing after I clear the table filters?
Check for another active filter, a slicer selection, or rows hidden manually. Clearing a table’s header filters does not necessarily clear slicers or unhide manually hidden rows.
Can I use Ctrl+Shift+L to clear all filters?
On Windows, Ctrl+Shift+L toggles AutoFilter controls; it is not the same as Data > Clear. Use Data > Clear when you want to remove the active filter criteria and show all table rows.
Related
- Protect Sheet in Excel: Allow Editing in Certain Cells
- Jira Merge Table Cells: Steps and Limitations
- Conditional Formatting: Highlight Duplicates in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Insert a Page Break in Excel? Yes, Here’s HowYes. In Excel for Microsoft 365 on Windows, select the row below or the column to the right…
- Excel Keyboard Shortcut to Select an Entire Row FastIn Excel for Microsoft 365 on Windows, press Shift+Space to select the entire worksheet row containing the active…
- Excel Column Letters: How to Find or Convert Them EasilyIn Excel, a column letter is the label at the top of a worksheet column: A is the…
- How to Change View Size in Outlook Email on Any ScreenTo change the size of an email in Outlook, adjust message zoom in classic Outlook for Windows, or…
- How to Indent Down in Excel: Cells, Text, and RowsIn Excel, indentation moves cell content horizontally, usually to the right; it does not move text down within…
- Google Sheets Day of the Week: Formulas and FormattingTo show the day of the week for a date in Google Sheets, enter =TEXT(A2,"dddd") in another cell,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.