How can I use the same validation for an entire column?
 

I want to use the same validation list for an enite column without having to
validate each row individually. Is this possible?

How can I use the same validation for an entire column?
 

Hi!

Copy the cell with the validation.

Select the range of cells where you want to copy the validation to.

EditPaste SpecialValidation

Biff

"me2jr2" wrote in message
...
I want to use the same validation list for an enite column without having
to
validate each row individually. Is this possible?

How can I use the same validation for an entire column?
 

Yes, select the range you want to validate and refer to the active cell in
the formula (if you select from A1 to A100
starting with A` it will be the active cell and if you use (as an example)

=A1="a"

that way if will change according for other cells


--
Regards,

Peo Sjoblom

(No private emails please)


"me2jr2" wrote in message
...
I want to use the same validation list for an enite column without having
to
validate each row individually. Is this possible?

How can I use the same validation for an entire column?
 

Thanks, but I tried that and what it pastes to subsequent cells is only
information stored in the cells on the same row as I am validating. My list
has 5 entries, therefore on the 6,7,8 and so on rows there are no items in
the list.

"Biff" wrote:

Hi!

Copy the cell with the validation.

Select the range of cells where you want to copy the validation to.

EditPaste SpecialValidation

Biff

"me2jr2" wrote in message
...
I want to use the same validation list for an enite column without having
to
validate each row individually. Is this possible?

How can I use the same validation for an entire column?
 

Biff, I'm sorry! I swear that I had tried that and it didn't work. I just
tried it again and Vola! It's there and works! What a time saver! I think
I must not have checked the correct item when choosing items in the
validation box. Thanks so much!

"me2jr2" wrote:

I want to use the same validation list for an enite column without having to
validate each row individually. Is this possible?