Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a way to format page orientation, margins for all worksh.
Is there a way to format margins and page orientation for all worksheets in a
workbook at the same time without the hassle of doing it worksheet by worksheet? |
#2
|
|||
|
|||
Deb
Right-click on first sheet tab and "select all sheets". Do your page setup on active sheet and it will be done to all sheets. If first sheet already has the settings you want, just do the FilePage Setup and OK. Settings will be transferred to other sheets. Note: you cannot set print range and rows to repeat at top. DO NOT FORGET to ungroup the sheets when Page Setup is complete. Gord Dibben Excel MVP On Mon, 31 Jan 2005 08:39:01 -0800, "Deb22" wrote: Is there a way to format margins and page orientation for all worksheets in a workbook at the same time without the hassle of doing it worksheet by worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page format | Excel Discussion (Misc queries) |