Office Settings & Configuration

How to Increase the Font Size of Excel Drop-Down Lists

Adam DavisAdam Davis Nov 3, 2026 869 views

Question details

The user wants to increase the font size of the text displayed inside an Excel data-validation drop-down menu.

How to Increase the Font Size of Excel Drop-Down Lists
Product
Microsoft Excel
Device & OS
Windows
Scenario
Working with data validation drop-down lists where the text is too small to read comfortably.
Observed behavior
Excel does not offer a dedicated font size setting for drop-down lists. The text size is linked to the overall zoom level, and the zoom slider becomes unresponsive if adjusted while the drop-down menu is actively open.
Before you start

Ensure your drop-down list is completely closed before adjusting any zoom settings, as Excel will not apply size changes while the menu is actively open.

Solution 1Recommended

Adjust the Excel Worksheet Zoom Level

Increase the zoom percentage of the entire spreadsheet to make the drop-down list text dynamically appear larger.

Because Excel does not have a separate font size control specifically for data-validation drop-down menus, the easiest workaround is to zoom in on your spreadsheet. This enlarges all on-screen elements, including the drop-down list.

1
Close the active drop-down list

Click on any empty cell in your spreadsheet to ensure that the drop-down arrow is not currently activated or expanded.

2
Locate the Zoom Slider

Find the zoom slider located at the bottom right corner of the Excel application window.

3
Increase the zoom percentage

Click and drag the zoom slider to the right (towards the plus sign) to increase the display scale. Alternatively, hold the 'Ctrl' key on your keyboard and scroll up with your mouse wheel.

4
Open the drop-down list

Click back onto the cell containing your drop-down list and click the arrow. The text will now reflect the new, larger zoom level.

Adjust the Excel Worksheet Zoom Level
Print Layout Unaffected: Adjusting the on-screen zoom slider only changes how the spreadsheet looks on your monitor. It will not alter the physical size of the font when you print the document.
Increase Drop-Down Size in WPS Spreadsheet

Easily Manage Spreadsheet Views with WPS Office

WPS Office provides highly responsive zoom controls for its spreadsheet tool, allowing you to quickly enlarge data validation drop-down lists. You can easily open your existing Excel workbooks and adjust the view without missing a beat.

  1. 1. Open Your Spreadsheet in WPS: Launch WPS Office and open your existing .xlsx file that contains the data validation drop-down lists.
  2. 2. Ensure Drop-Downs are Closed: Click anywhere on the grid away from your active cells to ensure no drop-down lists are open.
  3. 3. Adjust the View Zoom: Hold down the 'Ctrl' key and scroll up with your mouse wheel, or drag the zoom slider at the bottom right of the WPS interface to enlarge the view.
  4. 4. Interact with Your Data: Click the drop-down arrow in your target cell. The list options will be magnified and significantly easier to read.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formatsFamiliar UI with smooth and responsive zoom controlsLightweight program that opens large data files rapidlyCompletely free to download and use for your daily tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel zoom slider lock up when I try to use it?

The zoom slider becomes unresponsive if you try to adjust it while a drop-down menu or formula editing bar is actively engaged. You must close the drop-down list by clicking a different cell before you can successfully drag the zoom slider.

Is there a way to change only the drop-down font size without zooming the whole sheet?

Standard Excel data-validation lists do not support independent font size changes. However, advanced users can use an ActiveX Combo Box and VBA (Visual Basic for Applications) to create a custom drop-down list where the font size and style can be directly configured in the object properties.

Does increasing the Windows scaling change the actual file data?

No. Windows display scaling merely alters how the operating system renders applications on your monitor. It does not alter your spreadsheet data, cell dimensions, or how the document will appear when printed.