| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
From long dropdown to a short one
I used to have a longer list of dropdown in the cell name(top left of
worsheet) including names given by me to ranges. I had to reinstall XL and now I do not get more than 7 items unless I scroll down. Is there a setting to change it back to show all names when clicked? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
From long dropdown to a short one
Refer the below link
http://www.contextures.com/xlDataVal11.html If this post helps click Yes --------------- Jacob Skaria "XLFanatico" wrote: I used to have a longer list of dropdown in the cell name(top left of worsheet) including names given by me to ranges. I had to reinstall XL and now I do not get more than 7 items unless I scroll down. Is there a setting to change it back to show all names when clicked? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
| How do i break really long bars to show short ones in Excel? | Charts and Charting in Excel | |||
Linear Mode
