Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list formatting
I have a spreadsheet containing numerous drop down lists created through Data Validation. The contents for the lists are stored in named ranges in another tab within the same spreadsheet. The problem is that the drop down lists appear much wider than the cell (column) where they are situated. I've tried re-sizing the column that holds the 'named range' but this makes no difference. Also, when selected, the drop down list displays the bottom of the list 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. -- Ian31 ------------------------------------------------------------------------ Ian31's Profile: http://www.excelforum.com/member.php...o&userid=32116 View this thread: http://www.excelforum.com/showthread...hreadid=518706 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Drop Down List | Excel Worksheet Functions |