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.
Thanks to Corinne, from Digits Web Design & Branding, who suggested the following steps, that fixed the drop down width problem in her workbook:
To download a zipped sample file that shows the problem, click here: DataValWidth.zip
Last updated: June 29, 2022 9:10 AM