| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How many entries can be put into a drop down list in excel?
I am creating a drop down list in excel. I am not able to go any farther
than 15 cells with one or two word choices. Can someone tell me how many entries I can make? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How many entries can be put into a drop down list in excel?
On Wed, 26 Jul 2006 11:10:02 -0700, Mary A
wrote: I am creating a drop down list in excel. I am not able to go any farther than 15 cells with one or two word choices. Can someone tell me how many entries I can make? By experiment, my version of Excel 2002 allows 32767 entries in a drop down list. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List in Excel | New Users to Excel | |||
| Excel - how do I use drop down list to filter data | Excel Worksheet Functions | |||
| How do I set up a conditional cell from a drop down list in Excel | Excel Worksheet Functions | |||
| Deleting duplicate entries in an Excel list | Excel Worksheet Functions | |||
| Is there a way to make a drop down list in Excel that lets you se. | Excel Worksheet Functions | |||
Linear Mode
