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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


message
news:D[email protected]...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting sheets in a workbook 4
How do I copy the page set up from one worksheet to another? 2
Standard Deviation from one sheet to another 1
All sheets in workbook have same rows to repeat at top 1
printing page # on sheets 1
Conditional formatting of entire workbook 3
Worksheet several pages, Want name to show up on each page 2
The sum of data based on words 3

Back
Top