Excel Drop-Down Arrow Not Showing? How to Get It Back

When an Excel drop-down arrow is not showing, the cause is usually one of five things: the cell isn't selected, the "In-cell dropdown" box is off, objects are hidden, the validation was pasted over, or the source list is broken. This guide walks through each fix in order, from the quickest check to the rarer causes. It also covers filter arrows, which go missing for different reasons.

First check: is the cell selected?#

A data validation drop-down arrow appears only while the cell is selected. Click on another cell and the arrow disappears. That is how Excel works, not a fault.

So before you change any settings, click the exact cell that should have the list. If the arrow appears on the right of the cell, the list is fine.

Excel has no option to show the arrow all the time. If people miss your lists, give them a visual cue instead:

• Fill the list cells with a light colour.
• Add a note in the header, such as "Status (pick from list)".
• Put a small arrow symbol like ▼ in the cell to the right.

If you need a refresher on how the list was built, see how to create a drop-down list in Excel.

Turn on "In-cell dropdown"#

If the cell is selected and there is still no arrow, the list may exist but be set to hide its arrow. The cell still checks entries, but it gives you nothing to click.

1. Select the cell (or all the list cells).
2. Go to Data > Data Validation (on Windows the button may be labelled Data Validation or show only an icon; on a Mac it is also under the Data tab).
3. On the Settings tab, check that Allow says List.
4. Tick In-cell dropdown.
5. Click OK.

If Allow says Any value, the cell has no list at all. Jump to the section on pasted-over cells below.

Show hidden objects again#

Drop-down arrows count as objects, so Excel hides them when a workbook is set to hide objects. This setting also hides charts, shapes and pictures, which is a useful clue: if your charts are gone too, this is the cause.

On Windows:

1. Go to File > Options > Advanced.
2. Scroll to Display options for this workbook.
3. Under For objects, show, choose All.
4. Click OK.

There is also a shortcut. In many Windows versions, Ctrl+6 switches between showing and hiding objects, so a stray key press can cause the problem. Press it once more to switch them back.

On a Mac, look under Excel > Settings (called Preferences in older versions) > View for the matching objects option and set it to show all.

Did pasting remove the drop-down list?#

A normal paste copies everything about the source cell, including its validation. If you copy a plain cell and paste it over a list cell, the list is replaced with "no validation". The arrow is gone because the list is gone.

To fix it:

• Just pasted? Press Ctrl+Z (Mac: ⌘Z) to undo.
• Want to keep the list when pasting? Use Paste Special > Values (Windows: Ctrl+Alt+V; Mac: ⌃⌘V), then choose Values. Only the value goes in, and the validation stays.
• Need to find which cells still have lists? Press F5 (Mac: Ctrl+G), click Special, and choose Data validation > All. Excel selects every cell that has a rule.

To put the list back, select a cell that still has it, copy it, then select the broken cells and use Paste Special > Validation. This copies only the list rule, not the value.

While the arrow was missing, people may have typed values that aren't in the list. The exercise on this page counts those with COUNTIF and SUMPRODUCT. For other ways to stop bad entries, see data validation rules for numbers, dates and text.

Check the source list#

Sometimes the arrow shows, but the list is empty or Excel shows an error when you open Data Validation. That points to the Source box.

Open Data > Data Validation and look at Source:

A list on another sheet is a common setup and works well, but deleting that sheet breaks every drop-down that uses it. Renaming the sheet is safe, because Excel updates the reference for you. The guide to a drop-down list from another sheet shows the safest way to build one, and the worksheets and cross-sheet references lesson practises how formulas point at other tabs.

For a dependent drop-down list, the second list is empty until the first cell has a valid choice. If the first cell is blank or has a typo, the second arrow opens to nothing.

Is the sheet protected?#

On a protected sheet, you can only use a drop-down list in a cell that was unlocked before protection was turned on. If the cell is locked, Excel shows a protection message when you try to pick an item, and on some settings you can't even select the cell to see the arrow.

To fix it, go to Review > Unprotect Sheet, select the list cells, press Ctrl+1 (Mac: ⌘1), and on the Protection tab untick Locked. Then protect the sheet again. The guide on how to protect a sheet and lock cells explains this step by step.

Filter arrows not showing#

Filter arrows are the small buttons in a header row, and they have their own causes. The most common one is simple: the filter is off.

• Turn the filter on. Click a cell in the data and press Ctrl+Shift+L (Mac: ⌘⇧F), or go to Data > Filter.
• In an Excel table, click inside the table, open the Table Design tab and make sure Filter Button is ticked.
• Arrows on the wrong row? Excel guessed the header row. Turn the filter off, select the real header row plus the data, and turn it on again.
• On a protected sheet, filters only work if Use AutoFilter was allowed when the sheet was protected.
• Hidden objects hide filter arrows too, so the Ctrl+6 fix above applies here as well.

The filter a table lesson practises turning filters on and off, filtering by values and totalling only the visible rows.

Practise it#

Lists and filters are quick to fix once you know where Excel keeps their settings. Try the exercise on this page to find the bad entries typed while the arrow was missing. Then practise filters in a live spreadsheet, and use the cross-sheet references lesson to get comfortable with lists that live on another tab. Each lesson checks your work instantly.