Data validation

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
 
R

Ron de Bruin

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
 
N

Newbie

Thanks but the paste validation option is not availabe.
What do I need to do to make it available?
 
R

Ron de Bruin

The Validation option is greyed out
Ahh do you mean that

Then your sheet is protected
 
Top