Picklist - Data Validation

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
I've created a list and "name defined" this list as picklist.

I am then using data - validation - list option to allow me a drop-down menu, however, I only seem to be able to get 14 names and not the 30 that I need.

Am I missing a setting somewhere or are the lists restricted to 14?

Many thx

Gary
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Sounds like your range is only reading 14 lines

to resolve

Insert > Name > Define

Define the range where your list is, or extend as required

HTH
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
I have no idea then, sorry

I dont think validation lists are limited to a certain number of rows.....

Could be wrong?
 

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
Yes, it seem's quite strange.

I've tried re-defining the name, tried calling it something else, re-sorted the data and still only 14 names on the list?

Thanks for the help.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,679
Members
410,697
Latest member
srishtijain0708
Top