M
me2jr2
I want to use the same validation list for an enite column without having to
validate each row individually. Is this possible?
validate each row individually. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
Copy the cell with the validation.
Select the range of cells where you want to copy the validation to.
Edit>Paste Special>Validation
Biff
P
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)
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)
M
me2jr2
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.
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.
M
me2jr2
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!
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!