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"
wrote in message
...

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