| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown List - list item endings not visible if column too narrow
Hi,
I've created a drop-down list using the Data Validation function. When I went to use the dropdown list, I noticed I couldn't see the endings of some of the longer list items because the column was too narrow. If I made the column wider I could see the ending. Is there a simple way of increasing the width of a drop-down list (so I can see the list item endings) without increasing the column width. I need to fit quite a number of columns on a page, so making the columns the same width as the longest list item is not an option. Thanks AK |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown List - list item endings not visible if column too narrow
See http://www.contextures.com/xlDataVal08.html#Wider
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AK9955" wrote in message ... Hi, I've created a drop-down list using the Data Validation function. When I went to use the dropdown list, I noticed I couldn't see the endings of some of the longer list items because the column was too narrow. If I made the column wider I could see the ending. Is there a simple way of increasing the width of a drop-down list (so I can see the list item endings) without increasing the column width. I need to fit quite a number of columns on a page, so making the columns the same width as the longest list item is not an option. Thanks AK |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown List - list item endings not visible if column too na
Thanks Bob, I've learnt something new today. Worked woohoo!
"Bob Phillips" wrote: See http://www.contextures.com/xlDataVal08.html#Wider -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AK9955" wrote in message ... Hi, I've created a drop-down list using the Data Validation function. When I went to use the dropdown list, I noticed I couldn't see the endings of some of the longer list items because the column was too narrow. If I made the column wider I could see the ending. Is there a simple way of increasing the width of a drop-down list (so I can see the list item endings) without increasing the column width. I need to fit quite a number of columns on a page, so making the columns the same width as the longest list item is not an option. Thanks AK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| How increase # visible entries in dropdown list box so no scroll? | New Users to Excel | |||
| how do I keep the dropdown list button visible continuously | Excel Worksheet Functions | |||
| How can I set up to chose more than 1 item from a dropdown list (. | Excel Discussion (Misc queries) | |||
Linear Mode
