|
Posted to microsoft.public.excel.misc
|
|
|
Validation drop down box too large
"Debra Dalgleish" wrote:
Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
validation).
To get rid of them, you may have to delete the row or column and
recreate the data validation.
There's a bit more information he
http://www.contextures.com/xlDataValWidth.html
Depley wrote:
I have made drop down boxes for several columns in a workbook. The problem
is that the drop down box is too wide. For example, for a simple "Yes,No"
selection the drop down box is +/- 7 inches wide. Can I size the driop down
box to simply be the width of the column it is referring to? I have looked
everywhere, and in the process learned many things but have not found an
answer to my delemma. Any help would be greatly appreciated.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com
Thank all who responded. There were two merged cells but unmerging them did not work. Deleting the drop down validations and then reinserting new validation drop down boxes did not work. Nothing worked but Debra's response got me thinking, I inserted another worksheet, deleted all validations from the columns, copied the entire worksheet and pasted to the new worksheet, and then added back my validation drop down lists. All in the world is good again!!!!! Thank you.
|