Clear a Filter in an Excel Table: Steps and Options

Formulas & functions · Updated November 19, 2026

To clear a filter in an Excel table, open the drop-down arrow in the filtered column’s header and choose Clear Filter From followed by the column name. To clear the filters from the current worksheet at once, select Data > Sort & Filter > Clear. Clearing a filter shows the hidden rows again; it does not delete data or remove the table’s filter arrows.

What clearing a filter changes

An Excel filter controls which rows are visible. For example, a table of orders filtered to show only “Open” status still contains its other orders; Excel temporarily hides rows that do not meet the selected condition. Clearing the filter removes that condition so the rows can appear again.

This is different from deleting rows, removing the table, or turning off the filter controls. If the table has several filters—for example, Status is “Open” and Region is “West”—clearing only the Status filter leaves the Region filter in place. The results will still be limited to West, but will include every status in that region.

Clearing filters also does not necessarily put records back in their original order. A sort changes the order of rows, while a filter determines which rows are displayed. If the list still looks rearranged after clearing, check whether it has been sorted separately.

Clear a filter from one table column

In Excel for Microsoft 365 on Windows, use the column’s own menu when you want to remove just one condition and preserve other filters:

  1. Find the table header with the filter arrow. A funnel symbol on the arrow usually indicates that the column is filtered.
  2. Select the arrow in that header.
  3. Choose Clear Filter From [Column Name], where Excel substitutes the actual header name.

For example, suppose a table has columns for Date, Region, and Status. If Region is filtered to “West” and Status to “Open,” choose Clear Filter From Status to show all statuses for West. The Region filter remains active. Choose the corresponding Region command too if you want to see every region.

The command is available in the column’s menu when that column has an active filter. If you open a menu for an unfiltered column, you may not see a clear-filter command there. Look for the funnel icon in the headers to identify which columns are restricting the results.

Clear all filters from the worksheet

To reset filters together, select Data > Sort & Filter > Clear on the Windows ribbon. This clears filter criteria applied to the worksheet’s filtered lists, so rows hidden by those criteria can reappear. It keeps the table and its filter controls in place, allowing you to filter the data again.

There is also a clear-filter command in each column’s drop-down menu. That method is useful when you are working on one table or want to remove only a particular condition. The ribbon’s Clear command is the more convenient choice when you want a broad reset. If a worksheet contains multiple separate data ranges, check each range afterward; clearing one list should not be treated as a way to manage unrelated lists on other sheets.

On Excel for Mac, the column-header menus provide the same practical way to clear an individual filter. Ribbon wording and layout can vary slightly by release, so use the filter drop-down for a specific column if you cannot find the all-filters command. In Excel for the web, use the column’s filter menu as well; some ribbon controls may be arranged differently from the Windows desktop version.

Clear filters without removing the arrows

Many people who search for “clear filter” actually want to make every row visible but keep the ability to filter later. Use Clear Filter From in a column menu, or the ribbon’s Clear command, for that purpose. The drop-down arrows normally remain in the table header after the criteria are cleared.

To hide the arrows instead, turn off filtering. For a standard filtered range, select a cell in the range and choose Data > Filter to toggle the filter controls off. For a formatted Excel table, select a cell in the table, open the contextual Table Design tab, and clear the Filter Button check box. The table remains a table; this only hides its filter buttons. You can show them again by enabling the setting or turning Filter back on for a range.

Turning the controls off is not the same as clearing the criteria. If you want to keep arrows and restore visible rows, clear the filters first. If you simply turn off the controls, do not assume that you have reset every filter setting. This distinction matters when handing a workbook to someone else: a reader may see a shortened list and not realize that filter conditions are still limiting what is shown.

Check whether rows are still hidden

If clearing a filter does not make the expected rows visible, the rows may be hidden for another reason. Excel can hide rows manually, group them into an outline, or hide them through a different filtered range. A worksheet may also contain more than one table, each with its own filter state.

  • Check every table column. Look for funnel icons and clear any remaining column filters.
  • Check for manually hidden rows. Select the row headers above and below the missing section, right-click, and choose Unhide. You can also select the whole sheet using the corner button above row 1 and to the left of column A, then use Home > Format > Hide & Unhide > Unhide Rows.
  • Check grouped rows. If outline controls with plus and minus signs appear beside the row numbers, expand the group to show its details.
  • Check the active sheet. A filter on another worksheet is independent. Switch to the sheet where the missing records are expected and inspect its headers.
  • Check whether the data is in the table. Rows added below a table may not be part of it, especially if there is a blank row or column separating them.

Also check for a sort if records have returned but appear in an unexpected order. Clearing filters restores visibility, not a guaranteed historical arrangement. If you need a specific order, sort by a meaningful field such as date or an ID column.

Common filter problems and useful checks

The clear command is missing. You may have opened the menu for a column that is not filtered. Open the menu for a header showing the funnel icon, or use Data > Sort & Filter > Clear for a broader reset.

Some expected records still do not appear. More than one column may be filtered. Conditions in different columns work together: a row must meet all active criteria to remain visible. Clear the remaining filters one at a time or use the ribbon command, then check for hidden or grouped rows.

Clear is unavailable or appears to do nothing. Confirm that you are on the worksheet containing the filtered data and that a filter is active. If the sheet is protected, protection settings may restrict changes to filtering; ask the workbook owner or review the sheet’s protection options rather than trying to alter the data.

A filter arrow is not shown. The table may have its filter buttons turned off, or the range may not currently have filtering enabled. In a table, check Table Design > Filter Button. For a normal range, select the data and use Data > Filter. Avoid converting a table to a range just to restore the arrows; that changes the data structure and is usually unnecessary.

A filter selection seems to have changed. Excel may remember a previous selection or criteria while the workbook remains open. Reopen the header menu to inspect the active condition. If the goal is simply to display all records, use the clear command rather than manually selecting every checkbox; a clear action removes the criterion instead of replacing it with a long list of selections.

Keyboard shortcuts and safer ways to reset

On Windows, Ctrl+Shift+L toggles AutoFilter for a selected range. It is a shortcut for turning filter controls on or off, not the clearest way to remove one column’s filter while preserving the other filters. Use the column menu for that. On Mac, use the ribbon or the header menu if the shortcut differs on your keyboard or Excel release; menu paths are easier to verify than relying on a shortcut that may vary with the setup.

For a shared or important workbook, clearing filters is generally a low-risk change because it does not remove records. Still, if you are unsure whether a list has other conditions or a sort you need to preserve, note the current view before resetting it. You can also save a separate copy before making broader changes to the workbook. Do not use row deletion as a substitute for clearing a filter: visible rows are only the rows currently displayed, and deleting them can remove actual data.

Frequently Asked Questions

How do I clear only one filter in an Excel table?
Open the filter arrow in the column you want to reset and choose Clear Filter From [Column Name]. Filters in other columns remain active.

How do I clear all filters in Excel at once?
On Windows, select Data > Sort & Filter > Clear. This clears filter criteria from filtered lists on the worksheet while leaving the data and filter controls in place.

Does clearing a filter delete rows?
No. It removes the condition that was hiding rows, so matching and nonmatching records can be displayed again. It does not delete the underlying records.

Why are the filter arrows still there after I clear a filter?
The arrows are controls, not the filter condition. Clearing a condition leaves the controls available so you can apply another filter. Turn off the Filter Button setting or Data > Filter only if you want to hide the arrows.

Why are some rows still missing after I clear the filter?
Another column may still have a filter, or the rows may be manually hidden, grouped, on another sheet, or outside the table. Check the headers and row numbers before assuming the records were deleted.

Does clearing a filter undo a sort?
No. Filtering controls visibility; sorting changes row order. Clearing a filter may reveal all rows in the sorted order. Apply a new sort if you want a different arrangement.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.