Excel Table Not Showing Filter? Restore the Dropdowns

Formulas & functions · Updated November 19, 2026

If an Excel table is not showing filter arrows, click inside the table, open the Table Design tab, and turn on Filter Button in Table Style Options. If that option or tab is missing, check that the selected cells are still part of a table and that the table has a header row; those are the most common reasons the dropdowns seem to vanish.

How filters in an Excel table work

An Excel table is a structured data range, not just a block of cells with colored formatting. When you create a table with Insert > Table or the Home > Format as Table command, Excel normally adds a header row with a filter dropdown for each column. A dropdown lets you sort, search, and show or hide records by values in that field.

The filter controls belong on the table’s header row. They do not appear beside every cell, and they are different from the funnel icon that can appear on the ribbon when filtering is active. For example, a table with columns named Date, Region, and Amount has dropdowns on those three header cells. Choosing West from the Region dropdown hides other regions; it does not delete those rows.

Excel remembers the table’s data when a filter hides rows. Clear the filter to show them again. This distinction matters when a worksheet looks incomplete: a filter may be active even though its arrow is difficult to see. Check the row numbers for gaps or use the column dropdown’s clear-filter command before assuming data is missing.

Turn the table’s Filter Button back on

In Excel for Microsoft 365 on Windows, use these steps:

  1. Click any cell inside the table. The contextual Table Design tab should appear on the ribbon.
  2. Open Table Design and find Table Style Options.
  3. Select Filter Button. The dropdown arrows should return to the header cells.

If the tab does not appear, first click a cell you know belongs to the table rather than a nearby blank cell. If the ribbon is minimized, expand it or use the ribbon search box to locate the command. The exact arrangement of controls can vary with window width, but the Filter Button option is associated with the table’s design controls.

Turning this option on restores the visible controls; it does not clear existing filters or change the table’s data. If a column remains filtered, use its header dropdown and choose the command to clear that column’s filter. To show all rows across the table, use the clear-filter command for each filtered column, or use the relevant clear option on the Data tab.

Check the header row and table identity

A filter arrow can only appear in a table header. On Table Design, check that Header Row is enabled in Table Style Options. If the header row has been turned off, enable it. Excel will treat the first row of the table as the headings, so check that the labels are in the correct row before changing the setting.

Also confirm that Excel still recognizes the range as a table. Click inside the data and look for the contextual Table Design tab. If it does not appear, the cells may be an ordinary range, or the table may have been converted to a range. Formatting that resembles a table is not proof that the data is still a table.

To create a table from a normal range, select the data and choose Insert > Table. Confirm the range in the dialog, and select My table has headers if the first row contains field names. In a correctly structured list, each column should have one clear heading, such as Product, Date, or Quantity. Excel may supply or adjust headings if they are blank or repeated, so review the resulting header row.

Table filters versus filters on a normal range

Excel can also filter a regular range without converting it to a table. Select a cell in a single-row header range and choose Data > Filter, or use Home > Sort & Filter > Filter. In Windows desktop Excel, Ctrl+Shift+L toggles AutoFilter for the selected range. This is useful for a one-time list, but it is not the same as restoring a table’s own Filter Button setting.

Tables offer additional behavior: they expand as you add data directly below them, carry formatting and formulas into new rows, and use structured column names in formulas. A filtered normal range can be entirely adequate for a fixed list, but a table is usually more convenient for data that will grow or be reused. If a table’s Filter Button is off, using the ordinary Filter command may change AutoFilter state rather than address the table setting, so start with Table Design when the data is meant to remain a table.

Be careful when selecting a range manually for AutoFilter. Include the complete header row and all intended records, and avoid including unrelated notes or a second dataset. Excel uses the selected region to decide what belongs together; an incomplete selection can leave some records outside the filter.

Common reasons the arrows disappear

The Filter Button setting is the first thing to inspect, but several other conditions can explain what you see:

  • The active cell is outside the table. Click within the table to reveal its contextual tab and check its settings.
  • The header row is hidden as a table option. Turn on Header Row and verify the headings are actually in the first row of the table.
  • The table was converted to a range. Re-create the table if you need table features, or apply Data > Filter if a regular filtered range is sufficient.
  • The worksheet is protected. Protection can restrict filter use or changes. If you have permission, use Review > Unprotect Sheet; otherwise ask the workbook owner to allow filtering when protecting the sheet.
  • The ribbon or worksheet view is confusing the issue. Expand a minimized ribbon, check that you are on the expected sheet, and make sure you are looking at the actual header row rather than a title above it.
  • The column is very narrow. Widen the header column to make its dropdown easier to see and use. This is especially helpful when the heading itself takes most of the available space.

Tables do not support merged cells within their data area. If a range contains merged cells, it may not be possible to create or maintain it as a normal table until the layout is changed. A title centered across several columns should sit above the table, not be merged into its header row.

What to check when filtering is unavailable

Sometimes the arrows are visible but a user cannot apply or change a filter. Start by checking whether the sheet is protected. A protected worksheet can be configured to let users use AutoFilter, but the owner generally needs to set that permission when protecting the sheet. Protection settings vary by workbook, and removing protection may require authorization; do not try to bypass it.

Next, check whether the workbook is in a state that limits editing. A read-only copy or restricted shared file may let you inspect data without changing table settings. If commands are unavailable, save or open an editable copy only if you are authorized to do so, and check with the file owner before changing shared data.

If filtering works but returns unexpected results, inspect the source values. Extra spaces, inconsistent labels such as North and north, dates stored as text, or blank cells can make the dropdown list look different from what you expect. For example, a Region column containing both West and West followed by a space may show them as separate entries. Correct the underlying values rather than relying on a filter to treat inconsistent entries as identical.

Windows, Mac, and Excel for the web

The Windows steps above apply to Excel for Microsoft 365. In Excel for Mac, click inside the table and look for the contextual Table Design tab; its controls may be arranged differently from the Windows ribbon. Look in the table style options for Filter Button. The same basic distinction applies: table dropdowns are controlled through table settings, while a normal range uses the Filter command.

Excel for the web has a more compact ribbon and may present contextual table controls differently. Click in the table and inspect the table-related ribbon options; if the desktop-only setting is not apparent, open the workbook in the desktop app when available. Avoid assuming that a missing ribbon label means the data is not a table: confirm by selecting a cell and checking for table-specific options.

Keyboard shortcuts can be a quick alternative for a normal range. On Windows, Ctrl+Shift+L toggles filters for the selected data. For a table whose arrows were hidden with the Filter Button option, use the table controls instead so you are changing the setting that belongs to that table.

Prevent the problem in future worksheets

Good table structure makes filter behavior predictable. Keep one header row, use a distinct label for each column, and avoid blank separator rows inside the dataset. Put report titles, notes, and totals outside the data area unless you intentionally add a table Total Row through Table Design. When adding records, enter them directly below the table or in its last row so Excel can extend the table consistently.

If you share a protected workbook, decide whether recipients need to filter records and configure sheet protection accordingly. If they need only to view a filtered result, consider saving a clearly named view or explaining how to clear filters. This reduces confusion when someone opens the file and sees only a subset of its rows.

Finally, distinguish between hiding dropdowns and hiding rows. Turning off Filter Button removes the visible header controls; applying a filter hides nonmatching records; hiding worksheet rows manually is a separate action. Knowing which happened helps you choose the right repair instead of recreating the table unnecessarily.

Frequently Asked Questions

Why is Table Design not showing in Excel?
Table Design is a contextual tab, so it appears when the active cell is inside an Excel table. Click a cell in the data. If it still does not appear, the range may not be a table anymore, even if it has table-like formatting.

How do I add filter arrows to an Excel table?
Click in the table, open Table Design, and select Filter Button under Table Style Options. If the cells are a normal range instead, select the range and choose Data > Filter.

Does turning off the Filter Button delete my filters or data?
No. It hides the table’s header dropdowns; it does not delete records. A filter already applied may continue to hide rows, so turn the button back on or clear the relevant filters to see all records.

Why can I see filter arrows but not use them?
Worksheet protection, read-only access, or restrictions in a shared workbook may prevent changes. Ask the workbook owner to allow filtering or provide an editable copy if that is appropriate.

Can I filter an Excel list without making it a table?
Yes. Select the range and use Data > Filter. A table is useful when you want structured data features and automatic expansion, but a normal range can still use AutoFilter.

Related

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.