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

K

K_hotmail

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.
 
C

Chip Pearson

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


message
news:D[email protected]...
 
G

Gord Dibben

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
 
Top