Office Settings & Configuration

How to Create and Style an Excel Dropdown with Data Validation

Kushani Nimanthika Sep 25, 2026 873 views

Question details

The user wants to know how to create and style a dropdown menu using Data Validation, but may be incorrectly attempting to apply it directly to a shape rather than a cell.

Product: Excel
Device & OS: not provided
Scenario: Setting up a styled dropdown list in a spreadsheet to restrict data entry and improve visual design.
Observed behavior: Data validation works on standard worksheet cells but does not support being applied directly to shapes or objects.

Before you start

Prepare the list of items you want to include in your dropdown menu, either by typing them out or placing them in a dedicated column in your worksheet.

Solution 1Recommended

Create and Format a Dropdown List in a Cell

Since Data Validation cannot be applied to shapes, you must apply it to standard worksheet cells and use standard cell formatting to achieve your desired style.

Excel data validation is designed exclusively for cells. If you have seen instructions for adding a dropdown directly to a shape, they may be referring to Form Controls (like a Combo Box) rather than Data Validation.

Select the target cell

Click on the specific cell or range of cells where you want the dropdown menu to appear.

Open Data Validation

Navigate to the Data tab on the ribbon and click on Data Validation.

Set the validation criteria

In the Settings tab of the dialog box, choose 'List' from the Allow drop-down menu. In the Source box, enter your items separated by commas, or select the range of cells containing your list.

Style the cell

Click OK to create the dropdown. Go to the Home tab to style the cell by changing the background fill color, applying custom borders, and adjusting the font style to match your design needs.

Create and Format a Dropdown List in a Cell

Shape Limitations: Excel does not support applying Data Validation directly to a shape. You can only format the cell containing the dropdown.

Create and Style Dropdown Lists Effortlessly with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive interface for data validation, allowing you to quickly create, manage, and beautifully style dropdown lists for your data entry needs.

1. Select your cell: Click the cell where you want to insert the dropdown list in your WPS Spreadsheet.
2. Access Data Validation: Navigate to the Data tab and click on the Data Validation icon.
3. Configure the list: Choose 'List' from the Allow criteria, input your list items or select your source data range, and click OK.
4. Customize the style: Switch to the Home tab to customize the cell's background color, font size, and border styles to make your dropdown stand out.

Fully compatible with Microsoft Excel (.xlsx) file formatsIntuitive Data Validation menu for quick and error-free setupExtensive cell formatting options for custom styling and designLightweight, fast, and free to use

microsoft office alternative - wps office

Frequently Asked Questions

Can I attach a Data Validation dropdown list to a shape or button in Excel?

No, standard Excel Data Validation only applies to worksheet cells. If you need a dropdown menu on a shape or as a standalone clickable object, you must use a 'Combo Box' Form Control found under the Developer tab.

How do I change the color of the dropdown arrow itself?

Excel does not allow you to change the color, size, or style of the default dropdown arrow button. You can only format the cell containing the dropdown (such as changing its background color, borders, and text).

Why isn't my dropdown list showing the options?

Ensure that the source range you selected is correct and not empty. Additionally, check the Data Validation settings to confirm that the 'In-cell dropdown' checkbox is checked.

Office App Problems