Data Validation on several worksheets

S

SUSAN

I have 52 different worksheets i need to create data validation for, i can
not select all worksheets and create data validation? Is there any easy way
to do this without creating for all 52 worksheets?

Thank you!
Susan
 
J

Jim Thomlinson

Do your validation for one sheet. Copy the cells in that sheet. Select the
remaining sheets and Paste Special -> Validation
 
F

Farhad

Hi,

Lets say you want to put data validation in cells A1:A100 for 52 shetts
(same cells in each sheet) if this is what you want to do then try this:

put the data validation in the cells A1:A100 in the first sheet and then
select A1:A100 and click on copy. then go to second sheet and make cell A1
activate then hold Ctrl and then click on sheet tabs 3-52 and then click on
past.

Thanks,
 
S

slow386

If the Data-Val list would be the same for all sheets, I think you could
also create the list, highlight it, then Insert-Name-Define (name it), then
in the cells you need to use it on you 52 other sheets, Data-Val-List in the
list name box, enter =xxxxx

HTH
 
Top