P
Phil
Does 2007 allow all the page setup settings to be copied from one worksheet
to another worksheet?
to another worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas
Sure (as does other versions). Put both (all) the sheets in group mode by
activating the sheet with the page setups to copy, then ctrl/clicking the
2nd sheet (if ALL sheets, right-click the tab, select "Select All Sheets").
Now use the dialog launcher on the Page Layout Tab to get the Page Setup
dialog and simply click OK. All sheets will now have the same page setup
settings. Right-click any tab and select "Ungroup Sheets" to get out of
group mode.
HTH
Bob Umlas
Excel MVP
activating the sheet with the page setups to copy, then ctrl/clicking the
2nd sheet (if ALL sheets, right-click the tab, select "Select All Sheets").
Now use the dialog launcher on the Page Layout Tab to get the Page Setup
dialog and simply click OK. All sheets will now have the same page setup
settings. Right-click any tab and select "Ungroup Sheets" to get out of
group mode.
HTH
Bob Umlas
Excel MVP
P
Phil
Hi, Bob . . .
You nailed it. Thanks for your help!
Phil
You nailed it. Thanks for your help!
Phil
G
Gord Dibben
Note
Print Range and Rows to repeat at top cannot be duplicated on grouped
sheets.
Gord Dibben MS Excel MVP
Print Range and Rows to repeat at top cannot be duplicated on grouped
sheets.
Gord Dibben MS Excel MVP