Row limit in data validation drop down list?

C

CAToso

I've created a timesheet with a "project" cell that references a list o
project codes in a separate worksheet via data/validation/list.

My problem is that users are not able to see all the choices in th
list. There are currently 686 choices in the source list, but it'
cutting off approximately 20 of the items from the bottom of the list.

Does anyone have any ideas on how to get the whole list visible? I
there a limit of rows in a drop down like that? (I thought it was 100
rows.)

~Courtne
 
P

Paul Corrado

Not sure about row limits in data validation lists

However, 686 choices seems like a bit much to scroll through

Debra Dalgleish does a good job of describing how to create "dependent
lists." That may be a good way to group the lists into categories to make
scrolling easier.

http://www.contextures.com/xlDataVal02.html
 
R

RagDyer

I just tried a list with 1,300 entries, and everything works OK.

What's the possibility the you perhaps added items to the list, but forgot
to expand the named range to *include* the new additions?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I've created a timesheet with a "project" cell that references a list of
project codes in a separate worksheet via data/validation/list.

My problem is that users are not able to see all the choices in the
list. There are currently 686 choices in the source list, but it's
cutting off approximately 20 of the items from the bottom of the list.

Does anyone have any ideas on how to get the whole list visible? Is
there a limit of rows in a drop down like that? (I thought it was 1000
rows.)

~Courtney
 
D

Debra Dalgleish

Are you sure that all the cells are included in the named range on the
other sheet? To see the name definition, choose Insert>Name>Define, and
click on the list name.
 
Top