|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 13th 06, 08:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make longer a drop-down list (the window) in excel?
When I open a drop-down list in a celd (validation data) only appears 8 items
and I have 20. I can choose them (20) moving the slide bar, but I would like to see all the items (20) in the window. How can I do it? Sorry about my english Thank you Martin 
|
| Ads |
|
#2
January 13th 06, 08:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make longer a drop-down list (the window) in excel?
Martin
Cannot be done using DV. Must use a ComboBox or similar. See Debra Dalgleish's site for methods. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Fri, 13 Jan 2006 12:10:02 -0800, Martin > wrote: >When I open a drop-down list in a celd (validation data) only appears 8 items >and I have 20. I can choose them (20) moving the slide bar, but I would like >to see all the items (20) in the window. >How can I do it? >Sorry about my english >Thank you >Martin
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How may I make a list display in alphabetical order in Excel? | pat henry | Excel Discussion (Misc queries) | 1 | December 6th 05 08:09 PM |
| How can I create a monthly calender as a drop down list in excel? | Sarah Guest | Excel Discussion (Misc queries) | 1 | August 23rd 05 01:31 PM |
| How do I make other cells dependent on my drop down list? | mae1778 | Excel Discussion (Misc queries) | 1 | July 29th 05 04:25 PM |
| How do I create a combo drop down list in Excel? | Ron | Excel Worksheet Functions | 1 | April 15th 05 08:29 PM |
| How do I create a drop down list in Excel 2003 | Lenny | Excel Discussion (Misc queries) | 1 | February 17th 05 09:26 PM |
Linear Mode
