Contextures

Drop Down List Too Wide

Occasionally, a cell's drop down list becomes much wider than the column. Here are a couple of tips for trying to fix the problem, and a sample file that shows a wide list.

List Width Problem

The problem of wide drop down lists seems random, but I was able to duplicate the problem in a couple of files.

In most cases:

  • the worksheet had other cells with data validation in the same row
  • all dropdowns became the width of the widest dropdown.
  • one of the data validation lists is in a merged cell.

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 first saw this problem reported in the excel.programming newsgroup, by Cindy Winegarden, FoxPro MVP.

drop down list too wide

Attempt to Fix

In some workbooks, I've had success in resizing the dropdown width with these steps:

  • delete any columns that contain merged cells with data validation
  • resize all the columns
  • save and close the file.

Sometimes though, those steps didn't work, and I was not able to change the lists back to their normal width.

Sample File

To download a zipped sample file that shows the problem, click here: DataValWidth.zip

Related Links

Data Validation Basics

Data Validation Tips

Data Validation Documentation

Dependent Drop Down Lists

Data Validation With Combo Box

Get More Excel News

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

 

 

Last updated: March 8, 2017 10:41 PM
Contextures RSS Feed