Home |
Search |
Today's Posts |
#1
|
|||
|
|||
valadation for dropdown won't allow enough entries
When entering my data for a drop down menu, I'm being limited to only half
the entries I need to make. Is thera a way to change the properties to allow more entries? |
#2
|
|||
|
|||
How many entries do you want to make? and
how did you define the allowable entries? "Roger" wrote: When entering my data for a drop down menu, I'm being limited to only half the entries I need to make. Is thera a way to change the properties to allow more entries? |
#3
|
|||
|
|||
bj, thans for the quick responce.
I need to make approximately 50 entries. Defining allowable entries ? I guess this is what I need to do, how do I define allowable entries? Thank you for your help Roger "bj" wrote: How many entries do you want to make? and how did you define the allowable entries? "Roger" wrote: When entering my data for a drop down menu, I'm being limited to only half the entries I need to make. Is thera a way to change the properties to allow more entries? |
#4
|
|||
|
|||
Enter the values on a worksheet, then refer to that range in the data
validation dialog box. There are instructions he http://www.contextures.com/xlDataVal01.html Roger wrote: When entering my data for a drop down menu, I'm being limited to only half the entries I need to make. Is thera a way to change the properties to allow more entries? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Averaging the last 5 entries in a row | Excel Discussion (Misc queries) | |||
count data but avoid double entries | Excel Worksheet Functions |