Data validation

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I have data validation set up on a cell but I want the same validation to be
performed on all the cells in the column. Is there a way of doing this
without go into 60000 cells and setting it up manually

Thanks
 
Hi

Copy the cell with the validation(ctrl-C)
Select the cells where you want the same validation
Right click on them and choose Paste Special
Check Validation
OK
 
Thanks but the paste validation option is not availabe.
What do I need to do to make it available?
 
The Validation option is greyed out
Ahh do you mean that

Then your sheet is protected
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation 3
Data Validation on Locked Cell 2
If formula and Data Validation parallely 1
Preventing copy/paste on validated cells 2
2007 data validation not working 1
data validation 1
data - validation - list question 2

Back
Top