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


nicolebelle wrote:
> 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!!! ) 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!
>
>