Excel Online Filter Not Working? Fix Common Causes

If a filter is not working in Excel Online, select a cell in the data and choose Data > Filter; then check that the filter covers the full table and clear any criteria hiding the rows you expect to see. If the Filter command is unavailable or the arrows are missing, check whether you have editing access, whether the sheet is protected, and whether your data has blank rows or columns breaking it into separate ranges.

How filtering works in Excel for the web

Filtering hides rows that do not match the criteria you choose; it does not delete those rows or change the underlying values. For example, filtering a Status column to show only Open hides rows marked Closed, but you can bring them back by clearing the filter. This is different from deleting rows, and it is also different from sorting, which changes the order in which rows appear.

In a formatted Excel table, filter arrows usually appear in the header row automatically. For a regular range, use Data > Filter to add arrows to the selected data range. Open a column’s arrow to choose values or use the available text, number, or date criteria. The exact options depend on the kind of data in that column.

A filter works on a range, not on a general idea of what counts as the same dataset. If the range stops above newer records, those records will not respond to its filter. If blank rows or columns separate records, Excel may treat the data as multiple regions. Understanding that boundary explains many cases where a filter seems to ignore part of a worksheet.

Quick steps to restore a filter

Try these checks in order. After each change, look at the row numbers and records to confirm whether the expected rows have returned:

Click inside the dataset, then choose Data > Filter. If the arrows appear, open the relevant column menu and check whether a value or condition is selected.
In that menu, clear the filter for the affected column, or choose the option to select all values. Clearing a filter restores hidden matching rows; it does not remove the filter arrows.
Check other columns too. Filters on separate columns work together, so a row must meet the criteria in every filtered column to remain visible.
Look for blank rows or columns between the headers and records, and for records added below the filtered range. If needed, make the data a single continuous block or select the complete range before turning on Filter.
If the command is disabled, confirm that the workbook is open in editing mode and that you have permission to edit it. Check with the owner if the sheet or file is protected.
Refresh the browser tab if the page appears stuck, and reopen the workbook. If the problem persists, try another supported browser or open the file in the Excel desktop app to help determine whether it is specific to the web session.

When possible, make a copy before changing the structure of an important workbook. Filtering itself does not remove data, but deleting blank rows, changing headers, or rearranging a range can affect formulas and other users’ work.

Check the headers and the size of the data range

Each column should have one clear header in the top row of the filtered range. Use distinct labels such as Region, Order Date, and Status rather than leaving a header cell empty. Avoid putting a report title, notes, or a second header row directly above the records when you apply the filter; select the actual header row and its data instead.

Suppose a list has headers in row 1 and records through row 250, but a new entry was added in row 251 after the filter was created. If the filtered range ends at row 250, the new record may remain outside the filter. Select the full range, including the new row, and apply the filter again, or convert the list to a table so that it is easier to manage as a growing dataset.

Tables are useful when records are added regularly because their headers include filter controls and the table can expand as data is entered directly below it. To create one in Excel for the web, select the data and use Insert > Table, confirming whether the first row contains headers. Before doing this, check that the selection does not include unrelated notes or totals that should not be treated as records.

Keep each record on one row and each field in one column. Merged cells, repeated header rows within the data, and subtotals mixed into the records can make filtering confusing. A clean layout is not just cosmetic: it gives Excel a consistent set of values to evaluate and makes the filter menus easier to interpret.

Clear a filter without removing the arrows

People often say a filter is broken when it is simply still active. A column with a filter applied may show a filter indicator on its header. Open the menu and remove that column’s criteria, or select all available values. If the rows remain hidden, inspect the other column menus because one active criterion is enough to exclude a row.

Clearing a column’s filter and turning off Filter are different actions. Clearing the criteria displays the matching rows again while leaving the dropdown arrows available. Turning off the filter removes the arrows from a regular range; it does not normally erase the records. This distinction matters if you want to keep filtering available for the next person who opens the workbook.

Also check whether rows were hidden manually. Filtering and manual row hiding can look alike because both make rows disappear. Clearing the filter will not necessarily reveal rows hidden through row controls. If the row numbers skip, select the surrounding rows and use the row context menu to unhide them, or ask the workbook owner if you do not have permission to make that change.

Why the Filter command may be unavailable

A missing or disabled command is often a permission issue rather than a problem with the data. If the workbook is in view-only mode, you may be able to read it but not change its filter setup. Look for an editing option or request edit access from the owner. If the file is opened from a shared link, the owner’s sharing settings determine what you can do.

Worksheet protection is another possibility. A protected sheet can restrict changes to its contents and controls. Depending on how protection was set up, some actions may remain allowed while others are blocked. If the Filter command is disabled or the arrows cannot be changed, ask the person who protected the sheet whether filtering is permitted or whether they can adjust the protection settings. Do not assume that copying the data into another workbook is appropriate if it contains shared or sensitive information.

Some workbooks also contain unusual layouts, such as merged cells or multiple blocks of data. Excel may not recognize the intended range from the cell you clicked. Select the precise rectangular range, including its header row, before using Data > Filter. If the workbook is in a format or state that Excel for the web cannot edit fully, opening it in the desktop app may expose additional options; it does not override your access rights or protection settings.

Shared workbooks and Sheet View

In a workbook being edited by several people, one person’s filtering can affect what another person sees if everyone is working in the same view. Excel’s Sheet View feature is designed to let users sort and filter a worksheet without disrupting the shared view for everyone. In Excel for the web, look on the View tab for Sheet View options. Availability and labels can depend on the workbook and account.

If rows seem to vanish or reappear while you are collaborating, check whether you are in a personal sheet view or the default view, and ask whether another editor changed the shared filter. A sheet view is not a separate copy of the workbook: changes to cell values are still workbook changes. Its purpose is to separate certain display and analysis choices, not to isolate edits to the data itself.

For a shared report, agree on whether users should filter the common view or create their own sheet views. This avoids confusion when one person assumes a row was deleted while another has simply applied a filter. If the workbook is important, communicate before changing shared criteria that affect a presentation or review.

When the results look wrong

A filter can be working correctly even when its list of values looks unexpected. For example, cells that look like dates may be stored as text, or a column may contain extra spaces that make entries appear identical to a person but different to Excel. Values such as North, North with a trailing space, and north may not behave as one clean category in every operation. Review the source cells if a value is missing from the menu or matching rows are not grouped as expected.

Mixed data types can also make criteria confusing. A column containing numbers alongside text entries such as N/A may show different filtering choices than a column containing only numbers. Dates imported as text may not be treated as dates for date-based criteria. If the source came from a download or another system, correct the data format and clean inconsistent entries before relying on the filter for a report.

Finally, check for formulas that return an empty string, manually hidden rows, or formulas that recalculate to different values. A filter evaluates the values present in the cells; a row’s appearance alone does not tell you whether its contents are truly blank or what value Excel is evaluating. Inspect a sample cell directly when the visible result does not match your expectation.

Excel for the web compared with desktop Excel

The core filtering idea is the same in Excel for the web and Excel for Microsoft 365 on Windows: apply a filter to a range or table, then set criteria from the header menus. The web app is convenient for shared work and routine filtering, while the desktop app can be useful when a workbook has advanced features, complicated protection, or a layout that is difficult to manage in a browser.

Opening a file in desktop Excel can help diagnose whether a limitation is specific to the browser interface, but it is not a universal repair. The workbook may still be protected, the range may still be wrong, and a filter criterion may still hide the records. Avoid making a second, conflicting copy just to work around a view issue; when others rely on the workbook, coordinate changes in the shared original.

Frequently Asked Questions

Why are the filter arrows missing in Excel Online?
Click inside the data and choose Data > Filter. If the arrows still do not appear, check that you have edit access, that the worksheet is not restricting changes, and that you selected a range with a clear header row.

How do I show all rows again in Excel for the web?
Open each filtered column’s dropdown and clear its criteria or select all values. Check every column, because multiple filters are combined. If rows remain hidden afterward, they may have been hidden manually rather than filtered.

Why does my filter ignore new rows?
The new records may be outside the range to which the filter was applied. Extend the range to include them or use a table for a regularly growing list. Also check for a blank row or column separating the new records from the original data.

Can other people see my filter in a shared workbook?
They may if you change the workbook’s shared view. Use Sheet View options on the View tab when available to filter in a separate view, and check with collaborators if the displayed rows change unexpectedly.

Does clearing a filter delete data?
No. Clearing a filter makes rows that meet the cleared criteria visible again; it does not delete them. Turning off the filter removes the dropdown controls from a regular range, which is also different from deleting records.

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.