How to Get a Drop-Down Filter in Excel

To get drop-down filter arrows in Excel, select a cell in your data range, then choose Data > Filter. Excel adds an arrow to each header, letting you show rows that match selected values, text, dates, or numbers. Your data should have one clear header row and no completely blank rows or columns inside the range. If you mean a drop-down list for entering a value in a cell, that is a different feature; the guide below explains the difference too.

What You’ll Need

An Excel workbook with a range of related data, such as a list of orders, contacts, or inventory.
A header at the top of each column, such as Date, Customer, or Status. Use a different, nonblank heading for every column.
Microsoft Excel for Microsoft 365 on Windows for the ribbon paths below. Excel for Mac and Excel for the web offer the Filter command as well, though ribbon layout and some shortcuts may differ.

You do not need a formula, add-in, or special data format to use ordinary filters. Filtering hides rows that do not meet your choices; it does not delete them or change the values in those rows.

Step-by-Step

Check and arrange the data. Put one field in each column and one record in each row. For example, an order list might have Order ID, Date, Customer, Region, and Status as its headers, followed by one order per row. Make sure the header row is directly above the records. Remove any merged cells in the range, and avoid blank rows or columns that split the list into separate blocks. A blank cell within a record is fine; a fully blank row can make Excel treat the information below it as a different range.
Select the data range or click inside it. Click any cell in a continuous block of data. Excel will usually detect the surrounding range automatically. To be certain about the boundaries, drag to select the whole range, including the header row and all data rows. Do not include unrelated notes or a separate summary below the list. If you are selecting manually, check that the last column and last row are included.
Turn on Filter. On the Windows ribbon, choose Data > Filter. You can also use Home > Sort & Filter > Filter. A small drop-down arrow should appear at the right side of each header cell. In Windows desktop Excel, Ctrl+Shift+L toggles the filter buttons on and off. On Mac or Excel for the web, use the ribbon command if that shortcut does not work in your setup; keyboard mappings can vary by platform and keyboard.
Open a column’s drop-down. Click the arrow in the header for the column you want to filter. The menu typically includes a search box, a checklist of values, and commands for sorting or filtering. The options depend on the type of data in that column. For example, a Status column may show values such as Open, In Progress, and Closed, while a date column may offer date-based filtering choices.
Choose what to show. To show particular entries, clear (Select All), check the value or values you want to keep visible, then click OK. For example, in a Region column, selecting North and West shows records from those two regions and hides the others. To narrow the list by a text, number, or date condition, point to the relevant filter option, such as Text Filters or Date Filters, select a condition, enter the value if requested, and confirm. Available choices depend on the column’s contents.
Apply filters in more than one column if needed. Open another header arrow and make another selection. Excel combines the conditions, so a row remains visible only when it meets the active filters. For instance, filtering Region to North and Status to Open shows open records from the North region—not all open records and all northern records separately. Filter arrows or funnel icons indicate that a column has an active filter.
Review the results and clear filters when finished. Check the visible rows and the column arrows to confirm what is active. To remove one column’s condition, open its arrow and choose Clear Filter From [Column Name], where the name is the column heading. To clear filters across the range, use Data > Sort & Filter > Clear on the Windows ribbon. To remove the arrows entirely, choose Data > Filter again. Clearing or turning off a filter reveals hidden rows; it does not restore deleted information because filtering did not delete it.

Optional: format the range as a table. If you will keep adding records, click in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm the range and check My table has headers if the first row contains headings. Click OK. Excel tables display filter arrows by default and usually extend their formatting and filtering when you add rows immediately below the table. If you only need arrows once, the regular Filter command is enough.

In Excel for Mac, the Data tab also contains the Filter command; select the range and use that ribbon option. In Excel for the web, select a cell in the range and choose Data > Filter. The exact placement of commands can vary with the window size, but the feature works the same way: arrows appear on the headers, and the menu choices hide or show matching records.

Common Mistakes

There is no proper header row. Excel uses the first row of the selected range as the filter headings. If that row is data, the menu may show the wrong labels or treat a record as a heading. Add clear headings before applying the filter.
A blank row divides the list. If Excel detects only the block above the blank line, rows below it may not receive arrows or be included in the results. Remove the separator row, or deliberately select the complete range before turning on Filter.
The wrong range is selected. If the arrows appear on only part of the list, a table or filter may cover only part of the data. Check the range boundaries and include every relevant column and row. Keep unrelated notes outside the range.
Expecting the arrow to create a cell-entry list. A filter arrow is attached to a column heading and controls which existing rows are shown. It does not give users a list to choose from when typing into a cell. For that, use Data Validation instead.
Assuming filtered records were removed. A filter hides rows from view, which can make the row numbers look as though they skip. Clear the filter to reveal the records. Avoid selecting visible rows and deleting them unless deletion is what you intend.
Mixing data types in one column. If dates are stored as text in some rows and as actual dates in others, or numbers include inconsistent text, Excel may offer unexpected filtering categories. Keep each column consistent and correct the underlying entries if you need reliable date or number filters.

Tips

Use descriptive headings. Names such as Payment Status or Ship Date make it easier to identify the right arrow, especially when the list has many columns. Avoid blank or duplicate headings.
Search long value lists. The search box in a filter menu can be quicker than scrolling through hundreds of names. Search for a value, check the matching result, and confirm the selection before clicking OK.
Remember that filters stack. If a result seems too narrow, inspect every filtered column. A condition left active in another column may be excluding records you expected to see.
Use a table for a growing list. A table makes the data easier to extend and keeps filter controls with the list. Add new records directly beneath the table so Excel can include them. If new rows are not included, confirm they are part of the table rather than separated by a blank row.
Keep a source copy for important data. Filtering is nondestructive, but sorting changes row order and manual edits can still alter the workbook. Save a copy before making broad changes to important records.

Troubleshooting

No arrows appeared: Click inside the range and choose Data > Filter again. If the command is unavailable or the range behaves unexpectedly, check whether the worksheet is protected or whether the selected cells are part of a merged range. Unmerge cells in the data area, make sure the headings are in the first row of the range, and try selecting the full range before applying Filter.

Arrows appear, but some records are missing from the filter range: Clear the filter, inspect where the list begins and ends, and look for a blank row or column separating records. Select the complete block, including all headings and records, and turn Filter on again. If the data is a table, use the table’s Table Design tab to check or resize its range; the tab appears when a table cell is selected.

The filter menu does not show a value you can see in the sheet: First clear any search text in the menu and check whether another filter is limiting the rows. Then look for leading or trailing spaces, spelling differences, or mixed formats. For example, “Open” and “Open ” may be treated as different text. Correct inconsistent entries and reopen the menu. If a value is genuinely absent from the selected range, expand the range to include its row.

A date or number filter acts like a text filter: Excel may interpret some entries as text because they were imported or entered in a different format. Check a few cells, correct the inconsistent values, and apply the filter again. Changing only the displayed number format may not convert text into a real date or number; use an appropriate conversion method for the source data if needed.

You wanted a drop-down list inside a cell: Select the cell or cells where people should make a choice, then choose Data > Data Tools > Data Validation. In the dialog’s Settings tab, set Allow to List, provide the allowed entries in Source (or select a range containing them), and confirm that In-cell dropdown is enabled. Click OK. This creates an entry list; it does not filter the rows in your data table.

Frequently Asked Questions

Why does my Excel filter have a drop-down arrow?
The arrow is the control for filtering or sorting that column. Click it to choose which existing records to display or to apply a condition. A funnel icon usually indicates that a filter is active.

Can I filter by more than one value?
Yes. Open a column’s arrow, select several values in the checklist, and click OK. You can also set filters in multiple columns; Excel displays only rows that meet all active column conditions.

How do I remove the filter without deleting data?
Use Data > Sort & Filter > Clear to clear active conditions, or use the individual column menu to clear just one. Choose Data > Filter to toggle the arrows off. Clearing or switching off a filter does not delete the hidden rows.

Can I add filter arrows to a worksheet with blank rows?
You can, but a completely blank row can split the detected data into separate blocks. Remove the separator or select the entire range explicitly before choosing Filter. Blank cells within otherwise continuous records do not necessarily prevent filtering.

Is an Excel filter drop-down the same as a drop-down list?
No. A filter drop-down on a header hides or shows rows based on their existing values. A Data Validation list appears in a cell so someone can choose an allowed entry. Use the feature that matches whether you want to view records or enter data.

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.