Validation length, Range length
 

Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?

Validation length, Range length
 

I think the limit is the size of the sheet you are working on (65,532
rows and 256 columns in Excel 2003 and before). However, with a
validation list it would take a long time to scroll through to select
the item you want if you have such a big range - could you not
organize the data (eg alphabetically) and make use of dependent data
validation? Debra Dalgleish shows how he

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

Hope this helps.

Pete

On Sep 15, 12:08 am, I think I need to rephrase the question
osoft.com wrote:
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?

Validation length, Range length
 

A data validation list can contain up to 32,767 items.

and limit to the number of rows and columns in a range?

If you mean the size of a referenced range there is no limit (although there
are some limits imposed by certain functions and formula usage).

See this:

http://support.microsoft.com/kb/166342

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?

Validation length, Range length
 

Scrolling through the list is fast as I can jump large increments. I am
referencing a large database of information. Thanks for the advice

"Pete_UK" wrote:

I think the limit is the size of the sheet you are working on (65,532
rows and 256 columns in Excel 2003 and before). However, with a
validation list it would take a long time to scroll through to select
the item you want if you have such a big range - could you not
organize the data (eg alphabetically) and make use of dependent data
validation? Debra Dalgleish shows how he

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

Hope this helps.

Pete

On Sep 15, 12:08 am, I think I need to rephrase the question
osoft.com wrote:
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?

Validation length, Range length
 

I tested the validation and came up with the same row number. The range size
is handy to know for my data referencing. Thanks for the information.

"T. Valko" wrote:

A data validation list can contain up to 32,767 items.

and limit to the number of rows and columns in a range?

If you mean the size of a referenced range there is no limit (although there
are some limits imposed by certain functions and formula usage).

See this:

http://support.microsoft.com/kb/166342

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?

Validation length, Range length
 

You're welcome!

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
I tested the validation and came up with the same row number. The range
size
is handy to know for my data referencing. Thanks for the information.

"T. Valko" wrote:

A data validation list can contain up to 32,767 items.

and limit to the number of rows and columns in a range?

If you mean the size of a referenced range there is no limit (although
there
are some limits imposed by certain functions and formula usage).

See this:

http://support.microsoft.com/kb/166342

--
Biff
Microsoft Excel MVP


"I think I need to rephrase the question"
osoft.com wrote in
message ...
Can anybody tell me the limits on the number of rows available for a
validation list and limit to the number of rows and columns in a range?