Office Settings & Configuration

How to Display All Characters in an Excel Data Validation Drop-down List

Kushani Nimanthika Oct 16, 2026 868 views

Question details

The user wants to view the complete text of long entries in an Excel data validation drop-down list without the text being cut off.

How to Display All Characters in an Excel Data Validation Drop-down List

Product: Excel
Device & OS: not provided
Scenario: Selecting items with long text descriptions from a data validation drop-down menu situated in a narrow cell.
Observed behavior: Long entries in the drop-down list are truncated because the validated cell or column is too narrow, preventing the user from reading the full text options.

Before you start

Ensure the worksheet is not protected with a password, as column widths cannot be modified in locked sheets without unprotecting them first.

Solution 1Recommended

Increase the Validated Column Width

The simplest way to reveal truncated drop-down text is to widen the column containing the data validation cell, as the list width depends entirely on the cell width.

Data validation drop-down lists dynamically inherit the width of the cell they are placed in. Expanding the underlying column provides the space needed to display longer strings.

Select the target cell

Click on the cell that contains the data validation drop-down list with the truncated text.

Open the Format menu

Navigate to the Home tab on the Excel ribbon and locate the Cells group. Click on the Format button.

Adjust the column width

Select Column Width from the drop-down menu and enter a larger numerical value. Alternatively, choose AutoFit Column Width to automatically expand the column to fit the longest text string.

Quick Mouse Adjustment: You can also quickly widen the column by hovering over the boundary line between the column letters at the top of the worksheet and dragging it to the right.

Solution 2

Use a Form Control Combo Box

If your worksheet layout prevents widening the column, you can insert a Combo Box control, which allows for a wider drop-down list independent of the underlying cell width.

Manage Spreadsheets with WPS Office

Easily Adjust Column Widths and Data Validation in WPS Spreadsheet

WPS Spreadsheet provides intuitive and seamless tools for creating, formatting, and adjusting data validation lists, ensuring your long text entries are always fully visible.

1. Open your file in WPS: Launch WPS Spreadsheet and open the workbook containing your drop-down list.
2. Select the cell: Click the cell containing the data validation menu that is truncating characters.
3. Use the AutoFit feature: Go to the Home tab, click on Row/Column, and select AutoFit Column Width to instantly expand the drop-down visibility.
4. Modify data validation: If you wish to edit the drop-down text, go to the Data tab and click Validation to manage your list entries.

Fully compatible with Microsoft Excel (.xlsx) formats and featuresEasily adjust row and column dimensions with an intuitive AutoFit toolUser-friendly interface for managing advanced data validation rulesFree and lightweight alternative for everyday office tasks

Frequently Asked Questions

Why does my Excel drop-down list cut off words?

Standard Excel drop-down lists generated via Data Validation inherit the exact width of the cell they are placed in. If the column is too narrow to accommodate the length of the text, the items inside the drop-down menu will be visually truncated.

Can I change the font size of a data validation drop-down list to fit more text?

No, Excel does not provide an option to change the font size, style, or zoom level specifically inside a standard data validation drop-down list. You must either widen the column, use shorter text, or implement a Form Control Combo Box.

How do I make the drop-down list wider than the cell itself?

A standard data validation drop-down cannot be wider than its host cell. To achieve an independent width, you need to insert a Form Control Combo Box from the Developer tab, which acts as a floating object that you can resize as needed.

Does enabling 'Wrap Text' work inside an Excel drop-down list?

Enabling 'Wrap Text' applies only to the cell once a value is selected and confirmed. It does not affect the display of items within the open drop-down menu itself. The unselected list items will still appear on a single truncated line if the column is narrow.