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.
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:
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.
In some workbooks, I've had success in resizing the dropdown width with these steps:
Sometimes though, those steps didn't work, and I was not able to change the lists back to their normal width.
To download a zipped sample file that shows the problem, click here: DataValWidth.zip
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: May 14, 2019 12:45 PM
Contextures RSS Feed