Search Contextures Sites
Excel -- Data Validation -- Dropdown list too wide
Problem reported in excel.programming by Cindy Winegarden, FoxPro MVP.
A cell with Data Validation has a dropdown list that is much wider than the column.
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
Contextures Inc., Copyright ©2010
All rights reserved.
Last updated: April 10, 2010 8:20 PM