Data Validation

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

Guest

kshave multiple identacle sheets in a workbook(31 sheets). I am trying to
allow users to only enter whole numbers in some of these cells. I know I can
do it through Data /Validation/Allow - but, I want to do it on all 31 sheets
at once. When I select all sheets - Validation is greyed out. Should I be
using a different method?

Thanks,
Tom
 
Apply the data validation on Sheet1
Copy the cell(s) in which you applied data validation
Select Sheet2
Scroll to see sheet31
Hold the Shift key, and click on Sheet31 tab
Select the cell where you want to paste the data validation
Choose Edit>Paste
Click on Sheet1 to ungroup the sheets
 
You must log in or register to reply here.

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

Data Validation in another sheet 1
form validation determines which sheet to add data 1
[err] Excel 2007 - Data validation from another sheet? 1
how do you restrict the users from copying and pasting 1
Data Validation to exclude blank cells 6
data validation 1
Data Validation on Data Entry Form 1
Validation From List Not Working 4

Back
Top