Fix an Excel Data-Validation Drop-Down That Appears in the Wrong Location
Question details
The user needs to resolve an Excel data-validation drop-down list that appears in the wrong location or does not appear when selecting a cell in Microsoft 365 on Windows.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows
- Scenario
- When working in a workbook, the user selects a cell with a data-validation list, but the drop-down arrow or list appears away from the selected cell or fails to show.
- Observed behavior
- The data-validation drop-down appears in the wrong location or does not appear.
Before changing settings, save and close any unsaved workbooks, note the current worksheet zoom level and Microsoft 365 version, and make sure you can reopen the affected workbook after each test.
Set worksheet zoom to 100% and update Microsoft 365
Use this first because zoom scaling and outdated Office builds are common causes of misplaced data-validation drop-downs.
Excel drop-down rendering can be affected by non-100% zoom or display scaling. Updating Microsoft 365 also applies fixes for known list positioning issues.
Open the workbook in Excel, select the worksheet where the data-validation drop-down appears in the wrong location.
On the View tab, click Zoom, select 100%, and then click OK, or drag the zoom slider in the bottom-right corner to 100%.
Click File > Account > Update Options > Update Now, and allow Microsoft 365 to install any pending updates.
Select the cell containing data validation and confirm whether the drop-down now appears under the selected cell.

Run Excel in Safe Mode and disable add-ins
Use Safe Mode when an add-in or startup file is interfering with Excel's list rendering.
Check workbook integrity, display scaling, and repair Microsoft 365
Use this for persistent issues in one workbook or across multiple monitors, or after basic display fixes fail.
Open Excel Data-Validation Workbooks in WPS Spreadsheets
WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx and .xls workbooks with data-validation lists, so you can continue working when Microsoft 365 misplaces drop-down arrows.
- 1. Download WPS Office: Go to the official WPS Office site and click Download WPS Office Free, then install WPS Office on your Windows PC.
- 2. Open the affected workbook: Launch WPS Spreadsheets, click Menu > Open, and select the .xlsx or .xls workbook containing the data-validation list.
- 3. Use the data-validation drop-down: Select the cell with the data-validation list and verify that the drop-down appears under the active cell in WPS Spreadsheets.

Frequently Asked Questions
Why does my Excel data-validation drop-down appear far away from the selected cell?
This is usually caused by worksheet zoom, Windows display scaling, outdated Microsoft 365 builds, or add-ins. Set the worksheet zoom to 100%, update Microsoft 365, and test in Safe Mode.
Does WPS Office support Excel data-validation drop-down lists?
Yes. WPS Spreadsheets opens .xlsx and .xls workbooks and supports data-validation lists, so you can select the cell and use the drop-down without changing the Excel file format.
Can I repair Microsoft 365 if the drop-down still appears in the wrong location?
Yes. Go to Windows Settings > Apps > Installed apps, select Microsoft 365, click Modify, and run Quick Repair or Online Repair.
Will changing Windows display scaling fix Excel drop-down positioning?
It can help. Open Windows Settings > System > Display, set scaling to 100% or the recommended value, and temporarily use a single monitor if multiple monitors are connected.
Is this issue caused by workbook corruption?
If the problem occurs only in one workbook and follows the file to another computer, it may be corruption. Recreate the data-validation list in a new workbook to avoid the damaged file.




