Data Validation on several worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do your validation for one sheet. Copy the cells in that sheet. Select the
remaining sheets and Paste Special -> Validation
 
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,
 
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
 
Back
Top