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

[Guest]

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

 

[Biff]

Hi!

Copy the cell with the validation.

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

Edit>Paste Special>Validation

Biff

 

[Peo Sjoblom]

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)

 

[Guest]

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.

 

[Guest]

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!