Excel tables do not have a built-in setting to show filter arrows on only selected columns: the table’s Filter Button option shows or hides the arrows for the whole table. You can still filter by just the columns you choose, or use slicers and a VBA workaround if you need to limit which controls are visible.
What Excel table filters let you control
A filter arrow in a table header is a control for that column. It lets you display rows matching values or conditions in that field, while keeping the other columns in the table. You can use one column’s filter by itself, or combine filters across several columns. For example, a sales table could show orders from the West region without filtering the salesperson or product columns.
Showing an arrow does not mean that its column must be used as a filter. If you want to filter only by Region and Status, choose criteria from those two dropdowns and leave the rest alone. Excel applies the chosen filters together, so a row must meet the active criteria in each filtered column to remain visible. The unfiltered columns continue to display their values.
The distinction matters because readers often mean one of two things by “filter only certain columns”: use filter criteria on only selected fields, or hide the dropdown arrows in all the other headers. The first is available directly in Excel. The second is not a per-column table setting in the standard ribbon.
How filtering works across columns
Each table column has its own filter menu, and a filter can be active in more than one column at once. Within a column, you can select particular values, search the list, or choose relevant text, number, or date conditions. The menu options depend on the data type and the values in the column.
When filters are combined across columns, Excel generally treats them as an AND condition. If you filter Region to West and Status to Open, the visible rows must match both selections. Within a single column, selecting several listed values usually works as an OR: a row can match any selected value in that field.
To use only a few columns, open the dropdown for each field you want to filter, make a selection, and leave other fields unchanged. A funnel symbol in a header indicates that a filter is active there. To remove just one condition, open that column’s menu and choose Clear Filter From followed by the column name. To remove all table filters, use Data > Sort & Filter > Clear. Clearing filters displays the rows again; it does not delete the underlying data.
Filter a table using only selected fields
For Microsoft Excel for Microsoft 365 on Windows, these steps apply a filter to one or more chosen columns without changing which header arrows appear:
- Click a cell in the table so the table’s header and filter controls are available.
- Open the dropdown in the first column you want to use. Search for a value, select or clear values, or choose a condition from the menu.
- Choose OK or Apply if the menu presents that button. Excel hides rows that do not meet the selection.
- Repeat for any other column you want to include. Do not change the other columns’ menus.
- To revise the result, change the selections in the relevant dropdowns. To restore a field, clear its filter from that column’s menu.
For example, imagine a table with Order Date, Region, Salesperson, Product, and Status. To see open orders from the East, filter Region to East and Status to Open. You do not need to filter Order Date, Salesperson, or Product; those columns remain visible and show the information for matching rows.
Show or hide the filter arrows
If the goal is a cleaner-looking table rather than a restriction on the data, Excel’s built-in option affects all the table’s filter arrows together. Select a cell in the table, open the Table Design tab, and in Table Style Options clear the Filter Button checkbox. Select it again to show the arrows. This does not provide separate checkboxes for individual headers.
Hiding the buttons is different from clearing filter criteria. If a filter is already active, hiding the arrows does not necessarily restore the hidden rows; the table can remain filtered even though the controls are not shown. Before hiding them, clear any filters you do not intend to keep. If someone needs to change filters later, show the buttons again or provide another filtering control, such as slicers.
The Data > Filter command is another way to toggle AutoFilter controls for a selected data range, but it is not a per-column table setting either. For a formatted Excel table, use Table Design’s Filter Button option when you want to show or hide the table’s arrows. The exact ribbon layout can vary slightly with window size, but the command names are the same in current Windows Microsoft 365.
Use slicers when you want selected filter controls
Slicers are a practical no-code alternative when a worksheet should offer prominent controls for only certain fields. A slicer is a panel of buttons for a table column; selecting a button filters the table. You can add slicers for Region and Status, for example, and leave Product or Salesperson out of the visible controls.
To add them, click inside the table and choose Table Design > Insert Slicer. Select the fields you want represented and confirm. Move and resize the slicers as needed. If the purpose is to remove header dropdowns from the view, clear the table’s Filter Button option after setting up the slicers. Check first that no unwanted filters are active, and make sure users know how to clear a slicer selection.
Slicers do not make the table filter arrows individually configurable; they provide an additional way to filter. They are useful on dashboards and shared workbooks because the available fields are obvious and easier to click than small header menus. They also take up worksheet space, and a slicer is most helpful when its field has a manageable set of choices. Very long lists can make a slicer awkward to use.
Hide individual arrows with VBA
For a more technical Windows workaround, Excel’s VBA Range.AutoFilter method includes a VisibleDropDown argument for showing or hiding the dropdown for a field in an AutoFilter range. The field number is relative to the left edge of the range: Field 2 means the second table column, not necessarily worksheet column B. The following example targets a table named Sales on a worksheet named Data and hides the arrow for its second column.
Sub HideOneTableFilterArrow()
Dim ws As Worksheet
Dim tbl As ListObject
' Change these names to match the worksheet and table.
Set ws = ThisWorkbook.Worksheets("Data")
Set tbl = ws.ListObjects("Sales")
' Field 2 is the second column within the table range.
tbl.Range.AutoFilter Field:=2, VisibleDropDown:=False
End Sub
To show that dropdown again, run the same command with VisibleDropDown:=True. To use the macro, press Alt+F11 on Windows, choose Insert > Module in the Visual Basic Editor, paste the code, update the worksheet and table names, and run the procedure. Excel for the web cannot run VBA macros, and Microsoft documents Range.AutoFilter as unsupported on Excel for Mac, so this method is intended for Windows desktop Excel. Test it on a copy: macros cannot be undone with Ctrl+Z, and hiding an arrow can make the filter harder for other users to discover.
Common problems and misconceptions
- All arrows disappear at once. That is expected if you clear Table Design > Filter Button. The option is table-wide; it does not selectively remove one header’s arrow.
- Rows are still missing after arrows are hidden. The table may still have an active filter. Restore the buttons and clear the relevant filter, or use Data > Sort & Filter > Clear to clear all filters.
- A filter seems to affect the whole row. Excel hides entire records because a row must stay intact across the table. It does not hide only the nonmatching cell in the filtered column.
- New records do not appear in the result. Check whether the new data is actually part of the table and whether the active criteria exclude it. Typing directly below a table often expands it, but pasted data or blank separating rows can affect how a range is recognized.
- The filter list is incomplete or confusing. The dropdown reflects values in the column and the current filter state. Clear filters in other columns if you need to inspect a broader set of available records.
Also, a filter is not a permanent data cleanup. It changes which rows are displayed, not the stored values. Copying only visible rows, deleting rows, and clearing a filter are different actions; take care not to delete records when you only meant to narrow the view.
When another approach may fit better
If colleagues should be able to filter only approved fields, slicers are usually the clearest interface. If they need the complete table but should not alter its structure, you can protect the worksheet after setting up an appropriate workflow; however, protection settings can affect what users are allowed to filter, so verify the result with the permissions you plan to use.
If the purpose is to create a separate, changing view rather than operate the table’s dropdowns, consider a dedicated report sheet or a PivotTable. A PivotTable has its own field layout and filtering controls, which differ from a regular Excel table. It can summarize or rearrange data, so it is not a like-for-like replacement when users need to edit the original records. Choose the option based on whether you need a cleaner interface, a report, or simply fewer active filter criteria.
Frequently Asked Questions
Can I put a filter arrow on just one Excel table column?
Not through the standard table ribbon controls. Table Design > Filter Button shows or hides the arrows for the whole table. You can use criteria from just one column, add a slicer for selected fields, or use a Windows VBA workaround to hide individual dropdowns.
Can I filter two columns at the same time?
Yes. Choose a criterion in each column’s dropdown. Excel combines conditions across columns, so a row must meet all active column filters to remain visible.
Does hiding the filter buttons clear the filters?
No. Hiding the arrows is a display change, not the same as clearing the filter criteria. Show the arrows and clear the relevant column filters, or choose Data > Sort & Filter > Clear to clear all filters.
Can I filter a table with slicers but hide its arrows?
Yes. Insert slicers for the fields you want users to control, then clear Filter Button on the Table Design tab if you want to hide all header arrows. Slicers do not selectively hide individual arrows; they provide separate controls.
Can Excel for the web hide only selected table filter arrows?
There is no standard per-column table setting in the web interface. The built-in table Filter Button control is all-or-nothing, and Excel for the web does not run the VBA macro workaround described above.
Related
- Excel Shortcut to Select to the Bottom of a Column
- Excel Shortcut to Select All Rows in a Column at Once
- Excel Shortcut to Change Lowercase to Uppercase Text
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for the Higher of Two Values: MAX or IFTo return the higher of two values in Excel, use the MAX function. If the values are in…
- Align Right in Excel: Shortcut, Menu, and Mac KeysIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, A, R—one…
- Excel: Sum VLOOKUP Values Across Multiple Matching RowsTo total every row that matches a lookup value, use SUMIF, not a regular VLOOKUP: with the matching…
- Excel Test If a Cell Is Empty: Formulas and ExamplesTo test whether a cell is genuinely empty in Excel, use =ISBLANK(A1), replacing A1 with the cell you…
- Excel Compare Two Sheets for Matching Names: FormulasTo compare names in two worksheets, enter a formula beside the names on the first sheet and check…
- How to Multiply Different Cells in Excel With a FormulaTo multiply different cells in Excel, select an empty cell, type a formula that starts with an equals…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.