If you are manually setting the page setup parameters, you can Group two or
more worksheets. ANY change made to a sheet when sheets are grouped is made
to all the grouped sheets. Be SURE to ungroup the sheets once you are
finished; otherwise you may really screw things up, perhaps irretrievably
so.
To group a set of adjacent sheets, click the first sheet tab to be grouped,
hold down the SHIFT key and click on the last sheet to be grouped. To group
a set of non-adjacent sheets, click on the first sheet tab to be grouped,
hold down the CTRL key and click on all the other sheets to be grouped. The
word "[Group]" will appear in the Excel window caption.
Once the sheets are grouped, make your changes. Ungroup the sheets by either
clicking on the tab of a sheet that is not groups or right-click on a sheet
tab and choose Ungroup.
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
