To remove the filter arrows from an Excel table in Microsoft 365 for Windows, click a cell in the table, open Table Design, and clear Filter Button in Table Style Options. If you want to remove the filtering itself rather than just hide its arrows, clear the active filters or turn filtering off; these are different actions.
What an Excel table filter does
An Excel table includes filter controls in its header row. Each arrow opens options to sort that column or show only rows matching selected values or conditions. For example, a sales table can be filtered to show only orders from one region. Filtering hides nonmatching rows from view; it does not delete them or change their underlying values.
Because the filter controls are built into a table, removing them does not necessarily mean removing the table. A table still provides features such as structured references, automatic expansion when you add rows, and table formatting. The right action depends on what you mean by “remove filter.” You might want to show every row, hide the arrows, turn off filtering, or convert the table into a regular cell range.
Hide the filter arrows but keep the table
Use this option when the arrows clutter the header or readers should not change the displayed criteria, but you still want the data to remain an Excel table.
- Click any cell inside the table. The contextual Table Design tab appears on the ribbon.
- On Table Design, find Table Style Options.
- Clear the Filter Button checkbox.
The arrows disappear from the table headers, while the table and its formatting remain. To show the arrows again, select a table cell and check Filter Button. If your goal is to show every record before hiding the controls, clear the current filter first. Hiding the arrows is a display change, not a dependable substitute for clearing filter criteria.
If you cannot see Table Design, first click inside the table. If the tab still does not appear, the selected range may not be an Excel table; it may be a normal range with AutoFilter turned on. The distinction matters because the controls are in different places.
Clear a filter and show all rows
Choose this when rows are missing from view and you want to restore the full table while keeping the filter arrows available. Clearing a filter removes the current selection or condition, but leaves the table and its filtering controls in place.
- Clear all active filters: On the Windows ribbon, choose Data > Sort & Filter > Clear. This clears filtering across the current filtered data range or table.
- Clear one column: Open that column’s header dropdown and choose Clear Filter From followed by the column name. The wording may be shortened in the menu.
- Show all values in one column: Open its dropdown and select all values, or use the clear-filter command if one is available.
When a filter is active, Excel generally marks the filtered column’s dropdown differently from an unfiltered one, and some row numbers may be skipped because intervening rows are hidden. A quick check is to use Data > Sort & Filter > Clear. If the missing rows reappear, they were filtered out rather than deleted. A filter can also be active in more than one column, so clearing only one column may not restore every row.
Turn filtering off for a range
For a normal range with AutoFilter enabled, click a cell in the range and choose Data > Filter to toggle the filter controls off. The command removes the dropdown arrows and disables the range’s current AutoFilter. It does not delete the cell contents. If the data is a formal Excel table, prefer the table’s Filter Button setting when your intention is simply to hide its arrows while retaining table behavior.
On Windows, Ctrl+Shift+L toggles AutoFilter for the selected data range. It is a convenient shortcut, but first make sure the selection is in the intended range: applying the command to a different selection can add or remove filter controls there. If a filter is currently hiding rows, clear it before toggling off when you want to be certain all data is visible.
On Excel for Mac, use the ribbon’s Data > Filter command if you do not want to rely on a shortcut. The filter shortcut differs by keyboard setup and Excel version; the Mac shortcut commonly used for toggling filtering is Command+Shift+F. On Excel for the web, use the available Data tab or table header controls; ribbon layout and available table options can differ from the Windows desktop app.
Remove the table itself
If you want to stop using table features entirely, convert the table to a regular range. Click inside the table, open Table Design, and choose Convert to Range in the Tools group. Confirm the prompt. The cells and their data remain in the worksheet, and table formatting may remain as ordinary formatting, but table-specific behavior such as structured references and automatic table expansion is no longer available.
Converting to a range is more consequential than hiding filter arrows. It is appropriate when you specifically need a plain range, perhaps because another process expects ordinary cells. If you only want to remove the arrows, do not convert the table just to achieve that; use Filter Button instead. After conversion, check whether filter controls are still present and remove them with Data > Filter if needed. Do not assume that changing the table to a range also performs every separate filter-related action you intended.
How to choose the right option
Consider the outcome you need before changing the workbook. The table can keep its data and structure while you make a narrower change to the display or filter state.
- All rows should be visible, but arrows can stay: Clear the active filters.
- Arrows should be hidden, but the table should remain a table: Clear Filter Button on Table Design.
- Filtering should be switched off for a regular range: Use Data > Filter.
- The table’s special features are no longer wanted: Use Table Design > Convert to Range, then check whether any filter controls need a separate change.
For example, imagine a table with 500 orders and a filter showing only orders marked “Open.” If you clear the filter, all 500 rows become visible and the arrows remain. If you hide the arrows without clearing the active criteria, you may still see only the open orders. If you convert the table to a range, the data remains but table-specific features are removed. These outcomes are not interchangeable.
Common problems and checks
The arrows are gone, but some rows are still missing. The active filter may still be excluding rows. Use Data > Sort & Filter > Clear to show all records, then decide whether to hide the buttons.
Table Design is missing. Click inside the table, not a nearby cell. If the tab does not appear, the data may be a regular range. For a range, look under Data > Filter rather than searching for table options.
Clear is unavailable or does not change the view. There may be no active filter in the selected data, the selection may be outside the filtered range, or the hidden rows may have been hidden manually. Check the row numbers and use Home > Format > Hide & Unhide > Unhide Rows if rows were hidden rather than filtered. If a worksheet is protected, protection settings can also limit changes.
The arrows return after editing the workbook. Check whether you turned off the filter controls for the table or only changed a view or selection. Also check whether the data is a table or a normal range. Reopening a saved file or changing workbooks should not be treated as a way to remove filtering; make the intended change explicitly and save it.
Before making a structural change such as converting a table to a range, consider saving a copy if the workbook is important or shared. That makes it easier to recover table behavior if you later discover that formulas, formatting workflows, or data-entry steps depended on it.
Frequently Asked Questions
Does removing a filter delete hidden Excel rows?
No. A filter hides rows that do not match its criteria; clearing the filter makes them visible again. If rows were deleted, clearing a filter will not restore them.
Can I remove filter arrows without converting the table?
Yes. Click in the table, open Table Design, and clear Filter Button under Table Style Options. The table remains a table.
How do I remove a filter from just one column?
Open that column’s header dropdown and select Clear Filter From and its column name. Other columns’ filters can remain active.
Why does Excel still show only some rows after I hide the arrows?
Hiding the filter buttons is different from clearing the criteria. Use Data > Sort & Filter > Clear to remove active filters and show all matching records.
Will converting an Excel table to a range remove its formatting?
Conversion removes table functionality, but the cell data and table formatting can remain as ordinary worksheet formatting. It is not necessary if your only goal is to hide the filter arrows.
Related
- Quick Search in Excel: Find Data Fast
- Superscript in Excel: Quick Key and Formatting Steps
- Quick Key to Zoom In Excel: Shortcuts and Zoom Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel CONCAT Formula: Combine Two Columns With a SpaceTo combine two columns in Excel, enter =CONCAT(A2," ",B2) in a blank cell, replacing A2 and B2 with…
- Excel IF ISNUMBER: Check Whether a Cell Contains a NumberTo make Excel return one result when a cell contains a number and another when it does not,…
- Microsoft Excel Calendar Formula: Build a Monthly ViewIn Microsoft Excel for Microsoft 365, enter a year in B1 and a month number in C1, then…
- Excel Trim a Table: Clean Text or Remove Rows?To trim text inside an Excel table, add a column with =TRIM([@[Raw Name]]); to trim the table’s physical…
- COUNTA and COUNTIF in Excel: How to Use Them TogetherTo find what share of filled status cells say Complete, with statuses in B2:B11, use =COUNTIF(B2:B11,"Complete")/COUNTA(B2:B11). If five…
- Round Down in Excel: Formulas for Specific Decimal PlacesTo round a value down to a chosen number of decimal places in Excel, use the ROUNDDOWN function.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.