How to Hide Filter Arrows in Excel and Keep Table Filters

To hide filter arrows in Excel without removing a table’s AutoFilter setup, click inside the table, open Table Design, and clear Filter Button in the Table Style Options group. For a regular cell range, choose Data > Filter to remove the arrows, but note that this turns off the range’s filter controls. If you need to keep using filters, convert the range to a table first.

Filter arrows are the drop-down buttons in header cells. Hiding them can make a worksheet look cleaner or reduce clutter in a presentation, but the right method depends on whether your data is an Excel table or a standard range. The steps below explain the difference, how to check your result, and what to do if the arrows do not disappear.

What You’ll Need

An Excel workbook you can edit in Microsoft Excel for Microsoft 365 on Windows. If the workbook is shared or protected, you may need permission to change its layout or filters.
A clear idea of whether you want to hide the arrows but preserve the table’s filter setup, or turn off filtering altogether. These are different outcomes.
If you are converting a range to a table, a single header row and a contiguous block of data. Remove completely blank rows or columns within the block first, or check the range Excel selects before confirming.
Optional: if other people must filter the data while the arrows stay hidden, consider adding slicers to an Excel table. Slicers provide visible filter controls outside the header row.

Step-by-Step

Identify the kind of data you have. Click a cell in the data and look at the ribbon. If a contextual Table Design tab appears, the data is an Excel table. The table usually has a distinct style, but formatting alone is not proof: a normal range can also have banded rows and colored headers. If Table Design does not appear, you are probably working with a regular range. Click elsewhere and back into the data if you are unsure.
Choose whether you need filtering to remain available. If the arrows are on a table, you can hide the visible buttons without converting the data. The table keeps its AutoFilter setup, and any existing filtered view should remain in place. The header drop-downs will no longer be available for changing criteria until you show them again. If you have a regular range and simply want the arrows gone, you can switch off its filter. If you want the range to retain a table’s filter setup, convert it to a table instead.
For a table, click any cell inside it. This is necessary for Excel to show the contextual table controls. Select the Table Design tab on the ribbon. Depending on the width of the Excel window, the Table Style Options group may be compressed or partly hidden; widen the window or inspect the ribbon group if you cannot see its checkboxes.
Clear the Filter Button option. In Table Design > Table Style Options, clear the checkbox labeled Filter Button. The drop-down arrows should disappear from the table’s header row. This setting applies to the table as a whole; Excel’s ribbon does not provide a built-in control for hiding the button in just one selected table column while leaving the others visible.
Check the table and its existing filter state. Click outside the table and inspect the header row. Confirm that the arrows are no longer shown and that the rows are still displayed as expected. Hiding the buttons is not the same as clearing a filter: if the table was already filtered, some rows may remain hidden. To make the full data set visible, show the buttons again and clear the active criteria, or use the appropriate clear-filter command before hiding them.
Turn the buttons back on when you need the header controls. Click in the table, return to Table Design > Table Style Options, and select Filter Button. The drop-downs will reappear, allowing you to choose or clear filter criteria. This is a reversible display setting, so you can hide and show the buttons as needed.
If your data is a regular range and you do not need its filters, switch them off. Click a cell in the filtered range and select Data > Filter. This toggles AutoFilter off, removing the drop-down arrows. It also removes the range’s interactive filter controls; it does not merely conceal their appearance. If rows had been hidden by a filter, check the worksheet afterward and confirm that the records you expect are visible.
If you have a regular range but want to preserve a table-based filtering setup, convert it to a table. Select a cell in the data and choose Insert > Table, or use Ctrl+T on Windows. Review the range shown in the dialog, select My table has headers if the first row contains field names, and confirm. Then use the table steps above to clear Filter Button. Conversion can add table formatting and changes how Excel treats the data, so check the selected range and headers before confirming.
Consider a slicer if people need to filter while arrows are hidden. With a table selected, use Table Design > Insert Slicer, choose the fields you want to make available, and confirm. Position the slicer beside the table, then hide the header buttons using Filter Button. Users can filter by clicking slicer buttons. Slicers work for table fields, but they are not a way to expose every filter option available in a header drop-down.
Save and review the workbook in its intended view. Check that the table or range still fits the worksheet, that no rows are unexpectedly hidden, and that users can understand how to interact with the data. If the file will be opened in Excel for the web or on a Mac, confirm the display there too; ribbon placement and labels can vary by platform and window size.

Common Mistakes

Using Data > Filter when you only want to hide table arrows. That command toggles filtering for a normal range, and it is not the same as the table’s Filter Button setting. If your data is already a table, use Table Design > Table Style Options > Filter Button instead. If it is a range, decide whether losing its filter controls is acceptable before toggling the command.

Assuming hidden arrows mean all records are visible. Hiding table buttons does not necessarily clear criteria already applied. A table can have arrows hidden and still show only a subset of its rows. If records seem missing, restore the buttons and inspect the filters, or clear the filter criteria using the controls available for that data.

Formatting a range and assuming it is a table. Applying a color or banded-row style does not automatically turn a range into an Excel table. Check for the contextual Table Design tab after selecting a cell. If it is absent, use Insert > Table only if converting the range suits your workbook.

Expecting a per-column hide option. The table checkbox controls the filter buttons for the table, not one individual header. Deleting or changing a header cell is not a safe workaround: headers identify fields, and editing them can disrupt formulas, references, or connected processes.

Converting data without checking the selected range. If the table dialog excludes the last rows or includes unrelated cells, the table will not represent the intended data. Review the range in the dialog, verify the header setting, and avoid blank rows or columns inside the records when possible.

Tips

Keep a distinction between hiding a control and turning off a feature. For a table, clearing Filter Button hides the header arrows while leaving the table structure in place. For a standard range, Data > Filter turns the filter controls off. This difference matters when coworkers rely on the workbook, because they may need the arrows to change what is displayed.

If the goal is a clean printout or screenshot, you may not need to change the workbook’s filter settings at all. Consider copying the relevant results to a separate presentation sheet, or use Print Preview to check whether the arrows appear in the output you plan to share. Do not assume that hiding screen controls changes the underlying records or removes existing filter criteria.

When using slicers, give them clear labels and place them near the table. A slicer is especially useful when users need a simple way to choose categories, such as region or status, without seeing header arrows. Keep in mind that a slicer only controls the fields you add to it. To restore the full range of filtering choices, show the table’s Filter Buttons again.

For a reversible change, note the original setting before you hide the buttons. If someone later asks where the filters went, select a table cell and recheck Table Design > Table Style Options > Filter Button. On Excel for Mac, select the table to reveal its contextual design controls; names and ribbon layout can vary slightly by release. In Excel for the web, table controls may also be arranged differently, so look for the table-specific design options rather than assuming the Windows ribbon layout is identical.

Troubleshooting

The Filter Button checkbox is missing or unavailable. First click inside the table, not a nearby cell. If Table Design still does not appear, your selected data may be a regular range rather than a table. If the workbook or worksheet is protected, editing table settings may be restricted; ask the workbook owner or use the workbook’s permitted unprotected view.

The arrows remain after you cleared the checkbox. Make sure you changed Filter Button in the table’s Table Style Options, not a similarly named setting elsewhere. Confirm you are looking at the correct table if the sheet contains several. If the workbook is open in a different Excel version or the web app, save the change and reopen or refresh the workbook to check that the setting has been applied.

All filter arrows disappeared, but you meant to keep filtering. If the data is a regular range, choose Data > Filter again to restore its arrows, then convert it to a table if you specifically need to hide the buttons while keeping the table’s AutoFilter setup. If it is already a table, turn on Filter Button to restore the header controls.

Some rows are still missing. The table may still have filter criteria applied even though its arrows are hidden. Turn the buttons back on and inspect each field for an active filter, then clear the relevant criteria. Also check for manually hidden rows or columns; those are separate from filtering and will not necessarily be restored by changing the filter-button setting.

The table looks different after conversion. Excel tables can apply a style and use structured references in formulas. If the conversion was accidental, use Ctrl+Z immediately on Windows to undo it, provided you have not made other changes you need to keep. Otherwise, review the table’s style and range carefully. Avoid converting a range casually in a workbook that depends on a specific layout or external process.

Frequently Asked Questions

Can I hide filter arrows but still filter an Excel table?
Yes. Clear Table Design > Table Style Options > Filter Button to hide the table’s header buttons while keeping its table filter setup. To change criteria using the header menus, turn the buttons back on. Slicers can provide an alternate way to filter selected table fields.

Can I hide the arrows on just one column?
Not with the standard table ribbon checkbox. Filter Button hides or shows the buttons for the table as a whole. If you need different controls for particular fields, consider a slicer for chosen fields or redesign the layout; do not remove or rename headers as a shortcut.

Does hiding filter arrows delete my data?
No. Hiding a table’s buttons does not delete rows or values. Turning off filtering on a regular range also does not delete the records, though it removes the range’s filter controls. Always check for rows hidden by existing filters or by manual hiding if the visible list seems incomplete.

Will hiding the arrows clear filters already applied?
Hiding a table’s Filter Buttons is a display change and should not be treated as clearing criteria. Existing filters may continue to limit the visible rows. Restore the buttons and inspect or clear the criteria if you need to show every record.

How do I remove arrows from a normal range?
Select a cell in the range and choose Data > Filter to turn off its AutoFilter. This removes the arrows and the range’s interactive filter controls. To keep table-style filtering available while the arrows are hidden, convert the data to an Excel table and use the table’s Filter Button setting.

Do these steps work in Excel for Mac or the web?
The same distinction between a table and a regular range applies, but ribbon layout and labels can differ. In Mac Excel, select the table to reveal its design controls and look for Filter Button. In Excel for the web, use the table-specific ribbon options available in your version; if the setting is not shown, open the workbook in desktop Excel.

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.