Function Problems

How to Fix Missing In-Cell Dropdown in Excel Data Validation

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is unable to find or see the in-cell dropdown option when trying to configure Data Validation in a spreadsheet.

Product: Excel
Device & OS: not provided
Scenario: Creating a data validation dropdown menu to restrict cell input.
Observed behavior: The in-cell dropdown checkbox is missing from the data validation settings menu, preventing the user from creating a dropdown list.

Before you start

Ensure the cell where you want the dropdown to appear is actively selected and that the worksheet is not protected, as worksheet protection can restrict data validation changes.

Solution 1Recommended

Set Validation Criteria to List

The 'In-cell dropdown' option is exclusively available when the Data Validation type is set to 'List'. Changing the validation criteria will make the option visible.

Excel's Data Validation feature supports various rule types, such as Whole numbers, Dates, and Text length. However, the dropdown arrow functionality is specifically tied to the 'List' type. If any other type is selected, the in-cell dropdown checkbox will remain hidden.

Select the target cell

Click on the cell or highlight the range of cells where you want the dropdown list to appear.

Open Data Validation

Go to the 'Data' tab on the ribbon and click on 'Data Validation' in the Data Tools group.

Change validation type

In the Data Validation dialog box, go to the 'Settings' tab. Under the 'Allow' dropdown menu, select 'List'.

Enable the dropdown

Once 'List' is selected, the 'In-cell dropdown' checkbox will appear. Ensure it is checked, enter your source data, and click 'OK'.

Verify Source Data: Make sure your source data for the list does not contain empty cells that might cause the dropdown menu to appear blank when clicked.

Solution 2

Verify Office Version or Repair Installation

If the 'In-cell dropdown' option is still missing after selecting 'List', there may be a software glitch or a corrupted Office installation.

Create Dropdown Lists Easily

Create Data Validation Dropdowns Using WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive way to manage data validation. You can easily create in-cell dropdown lists without navigating complex, glitchy settings.

1. Open your workbook: Launch WPS Spreadsheet and open the file where you want to add a dropdown list.
2. Access validation tools: Select the target cell, navigate to the 'Data' tab, and click on 'Validation'.
3. Select list type: In the Settings tab, select 'List' from the 'Allow' drop-down menu to reveal the dropdown settings.
4. Apply settings: Check 'In-cell dropdown', select your source range or manually input your list items, and click 'OK'.

Highly compatible with Microsoft Excel (.xlsx) data validation rules.Intuitive interface for creating and managing dropdown lists.Free and lightweight alternative to heavy office suites.Cross-platform support for Windows, Mac, Linux, and mobile devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the data validation dropdown arrow not showing in my cell even after setup?

The dropdown arrow only appears when the cell containing the validation is actively selected. If the cell is selected and the arrow is still missing, ensure 'In-cell dropdown' is checked in your Data Validation settings, and that objects are not set to 'Hide All' in your advanced display options.

Can I use data validation without creating a dropdown list?

Yes, you can set validation criteria to Whole Number, Decimal, Date, Time, or Text Length. These options restrict the data that can be typed into the cell without displaying an in-cell dropdown arrow.

What should I do if my dropdown list shows blank items?

Blank items usually appear if your source range includes empty cells. Check the 'Ignore blank' option in the Data Validation settings or adjust your source data range to exclude any empty cells.

Excel & Data Problems