If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Worksheets in a Workbook
How do I set a global print format for many worksheets within workbook?
|
#2
|
|||
|
|||
Format Worksheets in a Workbook
Most print setup functions will be available for grouped sheets.
Right-click on a sheet tab and "select all sheets" Do your print setup on the active sheet and will be done to all sheets. NOTE.............you cannot set print range or rows to repeat at top using this method. Those must be set using code. Gord Dibben MS Excel MVP On Tue, 12 Sep 2006 08:21:02 -0700, vjboaz wrote: How do I set a global print format for many worksheets within workbook? |
Thread Tools | |
Display Modes | |
|
|