Validation Help

N

nicolebelle

Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
have the same headings (there are about 10 headings) underneath each
heading i have my drop down list (validations) that people need to
choose from. i need to format my whole gigantic worksheet like this,
but right now am only doing it 1 at a time (which is taking
forever!!!:eek: ) Does anybody know how to do this?? this is my first
time and there has got to be an easier way...any help would be greatly
appreciated!! thanks!
 
R

Roger Govier

Hi Nicole

Click on the first worksheet tab, hold down shift button and click on the
last worksheet tab. This will Group them and it will say Grouped at the top
of the screen.

Now, anything you do to any sheet, will be replicated across all others.
When you have finished, click on any single tab to Ungroup them.

Regards

Roger Govier
 
N

nicolebelle

Thank you all so much for the quick responses! I tried highlighting al
the tabs, and when i do that I am unable to choose validation of th
data pull down menu. I have tried also to copy the validation from on
worksheet to another and when i do that, i get a pull down menu but th
list is not there and there is some sort of error. ??? What am I doin
wrong??
 
G

Gord Dibben

nicole

You cannot group sheets and create a DV drop-down as you have found out.

On sheet1 if you type the list into the dialog box(comma de-limited) you can
copy to all the other sheets.

OR

If you have a named range for the list and use that named range in the list
dialog........ =TheList

You can copy the DV to all the other sheets.

In either case copy the DV cell from first sheet.

Select sheet2 then SHIFT + Select last sheet and Paste Special>All>OK>Esc.


Gord Dibben Excel MVP
 
N

nicolebelle

:) Great!! that helped me so much...thank you guys...my gigantic matri
is really coming along now...but i have another question...how can
protect my workbook so that my formatting and printsettings can't b
changed by others, I would like to limit those using the workbook t
only the drop down lists...is this possible?:confused: Thank
again!!
 
Top