I
Ian31
I have a spreadsheet containing numerous drop down lists created throug
Data Validation. The contents for the lists are stored in named range
in another tab within the same spreadsheet.
The problem is that the drop down lists appear much wider than the cel
(column) where they are situated. I've tried re-sizing the column tha
holds the 'named range' but this makes no difference.
Also, when selected, the drop down list displays the bottom of the lis
rather than the top.
Everything works properly but it just doesn't look like I want it to.
Any help would be much appreciated as it's driving me mad.
Thanks
Data Validation. The contents for the lists are stored in named range
in another tab within the same spreadsheet.
The problem is that the drop down lists appear much wider than the cel
(column) where they are situated. I've tried re-sizing the column tha
holds the 'named range' but this makes no difference.
Also, when selected, the drop down list displays the bottom of the lis
rather than the top.
Everything works properly but it just doesn't look like I want it to.
Any help would be much appreciated as it's driving me mad.
Thanks