Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
I have an excel spreadsheet where there is a list of "categories" (currently
only 10 entries, but can grow), and I would like all 10 entries to show in the pull-down list. It's only showing 8. There must be a setting somewhere where I can tell Excel to show complete list or increase the number showing.... isn't there? -- Thanks, Diane |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
Not if you are using datavalidation
-- Regards, Peo Sjoblom "DianeMcP" wrote in message ... I have an excel spreadsheet where there is a list of "categories" (currently only 10 entries, but can grow), and I would like all 10 entries to show in the pull-down list. It's only showing 8. There must be a setting somewhere where I can tell Excel to show complete list or increase the number showing.... isn't there? -- Thanks, Diane |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
Okay.....how do I do this without using data validation?
-- Thanks, Diane "Peo Sjoblom" wrote: Not if you are using datavalidation -- Regards, Peo Sjoblom "DianeMcP" wrote in message ... I have an excel spreadsheet where there is a list of "categories" (currently only 10 entries, but can grow), and I would like all 10 entries to show in the pull-down list. It's only showing 8. There must be a setting somewhere where I can tell Excel to show complete list or increase the number showing.... isn't there? -- Thanks, Diane |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
Use a combobox from the control toolbox toolbar, drag it to the sheet, right
click it and select properties, there you can select the ListRows (default is 8 but this is the one that you should change), you can put in the ListFillRange (same as the list size in the validation list box), you can set the LinkedCell. Once you are done you need to click the triangle to take it out of design mode. Some other neat options are match first letter entry -- Regards, Peo Sjoblom "DianeMcP" wrote in message ... Okay.....how do I do this without using data validation? -- Thanks, Diane "Peo Sjoblom" wrote: Not if you are using datavalidation -- Regards, Peo Sjoblom "DianeMcP" wrote in message ... I have an excel spreadsheet where there is a list of "categories" (currently only 10 entries, but can grow), and I would like all 10 entries to show in the pull-down list. It's only showing 8. There must be a setting somewhere where I can tell Excel to show complete list or increase the number showing.... isn't there? -- Thanks, Diane |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
I've got the combobox to show in my data sheet, but I've been having a hard
time trying to get my 10 row list into the ListFillRange. I was using a different sheet within the workbook to list the categories (as there is a possibility that this will grow). The sheet name is Categories. What's the syntax that I would use to put in ListFillRange? I've tried repeating the content of those 10 rows (separated by commas and by semi-colons). I've tried telling it to go to the Sheet, but maybe the format of the information I'm putting in is not corect. I can't find a sample in the help. Diane -- Thanks, Diane "Peo Sjoblom" wrote: Use a combobox from the control toolbox toolbar, drag it to the sheet, right click it and select properties, there you can select the ListRows (default is 8 but this is the one that you should change), you can put in the ListFillRange (same as the list size in the validation list box), you can set the LinkedCell. Once you are done you need to click the triangle to take it out of design mode. Some other neat options are match first letter entry -- Regards, Peo Sjoblom "DianeMcP" wrote in message ... Okay.....how do I do this without using data validation? -- Thanks, Diane "Peo Sjoblom" wrote: Not if you are using datavalidation -- Regards, Peo Sjoblom "DianeMcP" wrote in message ... I have an excel spreadsheet where there is a list of "categories" (currently only 10 entries, but can grow), and I would like all 10 entries to show in the pull-down list. It's only showing 8. There must be a setting somewhere where I can tell Excel to show complete list or increase the number showing.... isn't there? -- Thanks, Diane |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing full pull-down list
There are instructions here for using a combo box with data validation:
http://www.contextures.com/xlDataVal11.html DianeMcP wrote: I've got the combobox to show in my data sheet, but I've been having a hard time trying to get my 10 row list into the ListFillRange. I was using a different sheet within the workbook to list the categories (as there is a possibility that this will grow). The sheet name is Categories. What's the syntax that I would use to put in ListFillRange? I've tried repeating the content of those 10 rows (separated by commas and by semi-colons). I've tried telling it to go to the Sheet, but maybe the format of the information I'm putting in is not corect. I can't find a sample in the help. Diane -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ho to pull inmormation from a list? | Excel Worksheet Functions | |||
how do i get the full name list in a workbook ? | Excel Worksheet Functions | |||
Full Down List That Filters | Excel Discussion (Misc queries) | |||
How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) | |||
Text in cell not showing in full | Excel Discussion (Misc queries) |