Office Settings & Configuration

How to Make an Excel Data Validation Drop-Down List Scrollable

Khadija Khan Oct 10, 2026 869 views

Question details

The user needs to know how to enable scrolling and control the number of visible rows in a data validation drop-down list across different computers.

How to Make an Excel Data Validation Drop-Down List Scrollable

Product: Microsoft Excel
Device & OS: Windows
Scenario: Viewing and interacting with a data validation drop-down list in a Microsoft 365 Excel workbook on two different PCs.
Observed behavior: The same workbook displays 12 rows with mouse-wheel scrolling on one PC, but only 8 rows on another PC without the same scrolling behavior.

Before you start

Note that standard Excel data validation drop-down lists do not offer a built-in setting to specify an exact number of visible rows; they rely entirely on your application and system display settings.

Solution 1Recommended

Standardize Excel Versions and System Display Settings

Ensure both PCs are using the exact same Excel version and Windows display scaling to unify the drop-down list behavior.

The number of visible items in a standard data validation list is controlled by Excel's version, display scaling, window size, and operating system settings, rather than the workbook itself.

Update Excel to the Latest Version

Open Excel, click on 'File', select 'Account', click 'Update Options', and choose 'Update Now' to ensure both PCs are running identical Microsoft 365 builds.

Check Windows Display Scaling

Right-click the Windows desktop, select 'Display settings', and match the 'Scale and layout' percentage across both PCs so the interface renders uniformly.

Adjust the Application Window

Ensure the Excel application window is maximized on both monitors, as constrained window heights can force the drop-down list to truncate visible rows.

Standardize Excel Versions and System Display Settings

Mouse Wheel Scrolling: Mouse wheel scrolling inside data validation lists is supported in newer Microsoft 365 builds. If a PC cannot scroll using the mouse wheel, it may be running an older build.

Solution 2

Use a Combo Box for Precise Drop-Down Control

Replace standard data validation with a Form Control Combo Box to strictly define the exact number of visible rows.

Create Scrollable Drop-Down Lists in WPS Spreadsheet

WPS Spreadsheet offers a highly compatible and lightweight environment to create robust data validation drop-down lists and Form Controls that render consistently.

1. Open Your Workbook: Launch WPS Office and open your existing spreadsheet file.
2. Access Data Validation: Select the target cell, navigate to the 'Data' tab on the top ribbon, and click on 'Validation'.
3. Set Up the Drop-Down List: Under the 'Settings' tab, choose 'List' from the Allow drop-down, select your source data range, and click 'OK'.
4. Use Combo Boxes for Fixed Rows: If you require a strict row limit, navigate to the 'Developer' tab, click 'Insert', add a Combo Box, and adjust the 'Drop down lines' via Format Object.

Fully compatible with Microsoft Excel .xlsx and .xls formatsConsistent display rendering across different screens and devicesEasy-to-use Data Validation and Developer Form Control featuresLightweight application requiring minimal system resources

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my mouse wheel scroll the data validation drop-down in Excel?

Older versions of Excel do not natively support mouse-wheel scrolling for data validation lists. You must use the scrollbar on the side of the drop-down or update your software to a newer Microsoft 365 version.

Can I change the font size in an Excel data validation drop-down list?

No, standard Excel data validation lists do not provide a built-in feature to change the font size. The text size scales automatically with your Windows display zoom settings.

How do I create a searchable drop-down list?

Unless you are using the newest Excel 365 updates which support AutoComplete natively, standard data validation lists do not support typing to search. You can achieve this by inserting an ActiveX Combo Box and configuring its 'MatchEntry' property.

Is there a limit to how many items a data validation list can hold?

A data validation list can display up to 32,767 items if it is sourced from a worksheet cell range. However, extremely long lists are difficult to navigate without using a searchable Combo Box.

Office App Problems