Excel -- Data Validation -- Dropdown list too wide

List Width Problem

I was able to duplicate the problem in a couple of files. The worksheet had other cells with data validation in the same row, and all dropdowns became the width of the widest dropdown. In most cases, one of the data validation lists is in a merged cell.
To download a zipped sample file (6 kb), click here: DataValWidth.zip

Sometimes, I was unable to change them back to their normal width. However, the problem is sporadic -- sometimes the dropdown lists are the correct width when the file is opened. Next time, they're at the maximum width.

I've had some success in resizing the dropdown width if I deleted any columns that contained merged cells with data validation, resized all the columns, saved and closed the file.

Excel Tutorials - Data Validation

Data Validation Basics
Data Validation - Create Dependent Lists
Data Validation - Dependent Dropdowns from a Sorted List
Data Validation - Dependent Lists With INDEX
Hide Previously Used Items in a Dropdown List
Data Validation - Display Messages to the User
Data Validation - Display Input Messages in a Text Box
Data Validation - Use a List from Another Workbook
Data Validation Criteria Examples
Data Validation Custom Criteria Examples
Data Validation Tips
Data Validation Documentation
Data Validation Combo Box
Data Validation Combo Box - Named Ranges
Data Validation Combo Box -- Click
Data Validation - Add New Items

Home Excel Tips Excel Files The Excel Store Blog Contact

Contextures Inc., Copyright Š2010
All rights reserved.

Debra Dalgleish