Validation for multiple sheets?

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I was
hoping it would work like formatting over multiple sheets.

John
 
John said:
Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I
was hoping it would work like formatting over multiple sheets.

John
Click to expand...

If I well understand what you mean, you could simply copy the validation
from one sheet to another, not simultaneously validate them...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Franz said:
If I well understand what you mean, you could simply copy the validation
from one sheet to another, not simultaneously validate them...
Click to expand...

I have 60 sheets with 22 columns to be validated each. I would like a
faster way. I can't use copy because there is data in some of the
columns in some of the sheets.

I just learned about validation. I should have set this up before using
the sheets.

John
 
Copy the columns with validation on the first sheet
On the next sheet, select the columns where you want to apply the validation
Choose Edit>Paste Special, select Validation, and click OK
 
And if all sheets have the same layout, you can group them, then use
paste special to apply validation to all sheets simultaneously.
 
Back
Top