Page set up for a workbook, so each sheet gets the same format ?

I am trying to do a page set up on a workbook at once . I do not want to have
to go to each sheet individually for the set up before printing.

You can group the sheets, and any changes made to one of the
sheet will apply to all the sheets. Click the tab of your first
worksheet, hold down the SHIFT key and click on the last sheet.
All the sheet tabs will appear in white instead of default gray.
Make your changes then be sure to ungroup the sheets (right-click
and choose Ungroup).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"K_hotmail" <K_hotmail@discussions.microsoft.com> wrote in
message
news:DFAC603D-26C4-4367-A97E-06E477282233@microsoft.com...
>I am trying to do a page set up on a workbook at once . I do not
>want to have
> to go to each sheet individually for the set up before
> printing.

Please note if using Chip's suggestion.

Some print setup functions are not available with grouped sheets.

Row to repeat at top, columns to repeat at left, Print Range set up among these.

These settings require VBA code.


Gord Dibben MS Excel MVP

On Sun, 11 Jun 2006 11:45:02 -0700, K_hotmail
<K_hotmail@discussions.microsoft.com> wrote:

>I am trying to do a page set up on a workbook at once . I do not want to have
>to go to each sheet individually for the set up before printing.

Exchange lots of mouse moves and clicks for a single key press!
Significantly improve working speed by using shortcuts (hot keys).
Avoid Repetitive Strain Injury!

EnergyKey http://www30.webSamba.com/SmartStudio