Clear Filter Not Working in Excel? Fix the Cause

If Clear Filter is not bringing every row back in Excel, first choose Data > Sort & Filter > Clear while a cell in the filtered list is selected. If rows remain hidden, check for a second active filter, manually hidden rows, or a filter range that does not cover the data you expect; the Clear command removes filter criteria, but it does not undo every way a row can be hidden.

What Excel’s Clear command does

Excel’s filter arrows let you temporarily display records that match selected values or conditions. For example, filtering a Status column to show only Open hides the other records from view without deleting them. The Clear command removes the active filter criteria from the current filtered list, so its rows can appear again. It normally leaves the filter arrows in place, ready for another search.

There are two useful ways to clear a filter:

To clear all filter criteria from the current list, select a cell in the list and use Data > Sort & Filter > Clear.
To clear only one column’s criteria, open that column’s filter arrow and choose Clear Filter From [column name]. The wording includes the column name, such as Clear Filter From Status.

Be precise about the command you choose. The Filter button turns filtering controls on or off; it is not the same as clearing criteria in the usual workflow. If you only want to show all records while keeping the arrows available, use Clear rather than turning filtering off. A sort order is also separate from a filter: clearing a filter reveals rows, but does not necessarily restore the original row order.

Clear filters from every column

A common reason the list still looks incomplete is that more than one column has a filter. Suppose a sales table is filtered to Region = West and Status = Open. Clearing only the Region filter still leaves the Status filter active, so closed sales remain hidden. Excel combines filter criteria across columns; a record must satisfy the active criteria to be shown.

To remove all criteria at once in Excel for Microsoft 365 on Windows:

Click a cell inside the filtered range or Excel table.
Open the Data tab.
In the Sort & Filter group, select Clear.

Look at the filter arrows afterward. An arrow with a filter indicator, often a funnel, signals that a criterion remains active. You can open the arrow to see or clear that column’s selection. If you want to remove just one criterion, use that column’s menu and choose Clear Filter From [column name]. This is useful when you want to keep the other restrictions, such as showing Open orders across every region.

In Excel for Mac, the same general approach is available from the Data tab; the ribbon layout can differ slightly by version and window size. In Excel for the web, use the Data tab’s filter controls, or open the relevant column arrow and clear its filter. If you cannot find a command, expand the ribbon or use the application’s search box to locate Clear. The exact visible arrangement may differ, but the distinction between clearing criteria and turning filtering off remains important.

Check whether rows were hidden manually

Clear removes filter criteria; it does not unhide rows hidden with the row context menu, the Home tab, or a macro. Manually hidden rows can make it seem as though the filter failed, especially if the worksheet has been edited by several people. If the filter indicators show no active criteria but a row-number sequence skips—for example, row 14 is followed by row 18—some rows may be hidden.

To unhide rows in Excel for Windows, select the row headers on both sides of the missing rows, right-click the selection, and choose Unhide. To unhide all rows on a sheet, select the whole worksheet using the triangle at the top-left corner between the row numbers and column letters, then use Home > Format > Hide & Unhide > Unhide Rows. The same Home > Format menu is available on Mac, though the ribbon arrangement may vary. If rows are grouped, use the outline controls beside the row numbers to expand the group; clearing a filter does not expand a collapsed outline.

Also distinguish hidden rows from deleted records. If row numbers are continuous but expected data is absent, check whether the cells are blank, the data was moved, or the current list simply does not include those records. Unhiding cannot restore deleted content.

Verify the filter range includes all the data

Filters operate on a defined list or table. If new records were entered outside that area, they may not respond to the existing filter or appear when you clear it. A completely blank row or column between the original list and later data can cause Excel to treat the later cells as a separate region. This often happens when users paste additional records beneath a report.

Click inside the list and inspect where the filter arrows appear. Do they extend across the headers you expect? Does the last filtered row include the newest records? If not, the filter may cover only part of the data. For a regular range, remove or adjust the filter and select the complete rectangular data range, including its single header row, before applying Data > Filter. Avoid including unrelated notes or a second table in that selection.

For data that grows over time, converting the range to an Excel table is often a more reliable setup. Select a cell in the data and choose Insert > Table, then confirm whether the range has headers. Tables generally expand when you add data directly beneath them, and their filter arrows are attached to the table headers. Before converting, check that the data has one header row, consistent columns, and no blank separator rows. A table improves range management; it does not fix manually hidden rows or remove an active filter by itself.

Look for unusual data and filter conditions

A filter can be active even when its effect is not obvious. A text filter such as Begins With, a date range, a number condition, a color filter, or a search term in the dropdown can exclude records that are easy to overlook. Open each arrow with a filter indicator and inspect the selected values or condition. In a long value list, the search box may narrow the displayed choices; clear that search text if you are trying to inspect the full list of values.

Data that looks identical may not be identical to Excel. For instance, a cell containing West followed by a trailing space may be treated as a different value from West. Dates stored as text may also behave differently from real Excel dates, and mixed data types in one column can make filtering confusing. Clearing the filter should show all records in the list, but it will not clean or standardize the underlying values. If you need consistent categories, inspect representative cells and correct the source data rather than repeatedly applying a filter.

Color filters and custom criteria deserve particular attention. A color filter can remain active even when the visible values seem unrestricted, and a date filter may be based on a particular period rather than a simple list of dates. Use the column menu’s Clear Filter From command, or use the ribbon’s overall Clear command, then confirm that the filter indicator disappears.

Check worksheet protection and workbook state

If Clear is unavailable, or clicking it has no visible effect, check whether the worksheet is protected. Protection can restrict changes to filters depending on how the sheet was protected and which permissions were allowed. Look on the Review tab for Unprotect Sheet. If the sheet requires a password, ask its owner or workbook administrator; do not assume that clearing a filter should bypass protection.

Shared or coauthored workbooks can also create confusing views. Another person may have changed the filter, or a workbook may use a sheet view that preserves a user-specific arrangement. Check whether the workbook is in a personal sheet view or a shared view, and whether the displayed data is being changed by a refreshable external connection or PivotTable. A normal worksheet filter does not clear a PivotTable’s report filters, slicers, or timeline selections. Those controls must be cleared in their own menus.

If the workbook’s data comes from Power Query or another connection, refreshing can replace or update the rows, but refresh is not the same as clearing a worksheet filter. First establish whether the missing rows are merely hidden in the current view or absent from the loaded data. For a PivotTable, use its field dropdowns or connected slicers; for an ordinary table, use its header arrows and the Data tab’s Clear command.

When filter arrows disappear or the command seems ineffective

If the arrows themselves have disappeared, filtering may have been turned off rather than cleared. Select a cell in the list and choose Data > Filter to display the controls again. On Windows, Ctrl+Shift+L toggles AutoFilter on or off; on Mac, Command+Shift+F is commonly used for the same toggle, though shortcuts can vary with keyboard settings. Use the ribbon when unsure. Toggling is not the best first fix if you want to preserve your existing filter setup.

If Clear is disabled, click inside the actual filtered list rather than a blank cell elsewhere on the worksheet, and check that the sheet allows filtering. If it remains disabled, there may be no active filter criteria to clear. In that case, inspect manually hidden rows, collapsed outline groups, table boundaries, and PivotTable controls. A worksheet can also contain more than one independent filtered range, so clearing one list does not necessarily change another list elsewhere on the sheet.

A useful diagnostic is to clear one column from its dropdown, then observe whether the visible row count changes. If it does, another column may still be filtering records. If it does not and the filter indicator is gone, investigate hidden rows or the range itself. This small check helps separate a filter problem from a display or data-layout problem.

A reliable troubleshooting order

Work from the simplest explanation to the less common ones, and avoid changing the source data until you know what is hiding the records:

Select a cell in the relevant list and choose Data > Sort & Filter > Clear.
Inspect every header arrow for a remaining funnel or filtered selection; clear individual columns if needed.
Check row numbers for gaps and unhide rows or expand outline groups.
Confirm that the filtered range or table reaches the last expected record and includes the intended columns.
Check for a PivotTable, slicer, color filter, custom condition, or search text that uses a separate control.
Check worksheet protection and whether a shared or personal view is affecting what you see.

Once all records are visible, consider turning the data into a table if its size changes regularly. Keep one clear header row, avoid blank separator rows inside the list, and use consistent data types within each column. These habits make filters easier to understand and reduce the chance that new records fall outside the range. They do not prevent every issue, but they make the source of a filter problem easier to identify.

Frequently Asked Questions

Does Clear Filter delete rows in Excel?
No. Clearing a filter changes which existing rows are displayed; it does not delete the hidden records. If rows remain absent after clearing, check for manual hiding, an incomplete range, or a separate control such as a PivotTable filter.

How do I clear all filters in Excel at once?
Select a cell in the filtered list and choose Data > Sort & Filter > Clear. This clears filter criteria for that list while leaving its filter controls available. A separate table elsewhere on the sheet may need to be cleared separately.

Why are some rows still missing after I clear a filter?
They may have been hidden manually, included in a collapsed outline group, excluded from the filtered range, or hidden by a PivotTable or slicer. Check row-number gaps and identify which type of list or control you are using.

How do I show filter arrows again?
Click in the data and choose Data > Filter. This turns the filter controls on or off; it is different from clearing filter criteria. If the data is a table, its header arrows are part of the table controls.

Why does Clear not include newly added rows?
The new records may sit outside the original filter range, particularly if a blank row or column separates them from the list. Expand the range or use an Excel table that can grow with data entered directly below it.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.