Hold down the SHIFT key, click on the tabs for the sheets to include (this
is 'grouping')
Make the format changes needed
Right click a worksheet tab and select Ungroup
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nicolebelle" <[email protected]>
wrote in message
news:[email protected]...
>
> Hello--i have a multi-tabbed workbook and am continually batteling with
> Excel to have consistent formatting i.e. same size rows etc.. how do i
> do this? i have been doing paste special: formats, however it doesn't
> always work. also is there a way to "lock" a page in some fashion so
> that all worksheets have the same margins and spacing? Any info 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=505709
>