| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum Items in Excel Lists?
I can only get 14 items to show up in an excel drop down list. Is that the
maximum # or can I get it to increase? Thanks, Matt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
A data validation (drop-down) list can have thousands of items. Exactly
what are you doing (step by step) to create this Data Validation cell? HTH Otto "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
Matt
Where is this drop down from? I know of no limit so small Forms toolbox Control toolbox Data validation Autofilter -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
Otto,
On Sheet 2, I have a column "Category List" with 30 items. On Sheet 1, I have a column labeled "Category" and went to the cells under it and clicked Data/Validation/Allow Lists and under Source put "=Category". The drop down button appears and a list appears but it only scrolls down through the first 14 items. Matt "Otto Moehrbach" wrote: A data validation (drop-down) list can have thousands of items. Exactly what are you doing (step by step) to create this Data Validation cell? HTH Otto "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
Matt
Better to name the range rather than rely on a label or type in a A1 notation address in the source box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "MattPatsFan" wrote in message ... Otto, On Sheet 2, I have a column "Category List" with 30 items. On Sheet 1, I have a column labeled "Category" and went to the cells under it and clicked Data/Validation/Allow Lists and under Source put "=Category". The drop down button appears and a list appears but it only scrolls down through the first 14 items. Matt "Otto Moehrbach" wrote: A data validation (drop-down) list can have thousands of items. Exactly what are you doing (step by step) to create this Data Validation cell? HTH Otto "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
I have it in a regular cell dropdown. The list is on sheet 2 and the drop
down is on sheet one. I am doing a real basic list for budgeting purposes. I went to data/validation/allow lists/and put =category in the source section. Matt "Nick Hodge" wrote: Matt Where is this drop down from? I know of no limit so small Forms toolbox Control toolbox Data validation Autofilter -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
Nick,
How do I name the range? Would it be possible to email you the spreadsheet I am talking about? Matt "Nick Hodge" wrote: Matt Better to name the range rather than rely on a label or type in a A1 notation address in the source box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "MattPatsFan" wrote in message ... Otto, On Sheet 2, I have a column "Category List" with 30 items. On Sheet 1, I have a column labeled "Category" and went to the cells under it and clicked Data/Validation/Allow Lists and under Source put "=Category". The drop down button appears and a list appears but it only scrolls down through the first 14 items. Matt "Otto Moehrbach" wrote: A data validation (drop-down) list can have thousands of items. Exactly what are you doing (step by step) to create this Data Validation cell? HTH Otto "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Maximum Items in Excel Lists?
Select the entire list of categories on the sheet, don't include the label at
the top of the list, then Use Insert | Name | Define and type in a name for the range like myCategoryList It should show the cells selected in the area at the bottom of the dialog. Click the OK button. Now in your data validated cells use =myCategoryList as the Source for the list. Excel should also offer to make the same to all of the adjoining cells with the same validation setup as the one you've selected. Accept that kind, labor saving offer. "MattPatsFan" wrote: Nick, How do I name the range? Would it be possible to email you the spreadsheet I am talking about? Matt "Nick Hodge" wrote: Matt Better to name the range rather than rely on a label or type in a A1 notation address in the source box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "MattPatsFan" wrote in message ... Otto, On Sheet 2, I have a column "Category List" with 30 items. On Sheet 1, I have a column labeled "Category" and went to the cells under it and clicked Data/Validation/Allow Lists and under Source put "=Category". The drop down button appears and a list appears but it only scrolls down through the first 14 items. Matt "Otto Moehrbach" wrote: A data validation (drop-down) list can have thousands of items. Exactly what are you doing (step by step) to create this Data Validation cell? HTH Otto "MattPatsFan" wrote in message ... I can only get 14 items to show up in an excel drop down list. Is that the maximum # or can I get it to increase? Thanks, Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2000 opens LARGER than maximum | Excel Discussion (Misc queries) | |||
| drop-down lists print on a separate page in excel | Excel Worksheet Functions | |||
| How do I get Excel to automatically group items? | Excel Discussion (Misc queries) | |||
| How can I merge different lists in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
