If you select all sheets all the things you do in one sheet will be done in
all the sheets, don't forget to ungroup the sheets when you are done


--

Regards,

Peo Sjoblom

"nicolebelle" <nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com>
wrote in message
news:nicolebelle.1ynlbb_1132251603.1702@excelforum-nospam.com...
>
> 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!
>
>
> --
> nicolebelle
> ------------------------------------------------------------------------
> nicolebelle's Profile:
http://www.excelforum.com/member.php...o&userid=28847
> View this thread: http://www.excelforum.com/showthread...hreadid=485968
>