| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing
Does 2007 allow all the page setup settings to be copied from one worksheet
to another worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing
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 "Phil" wrote in message ... Does 2007 allow all the page setup settings to be copied from one worksheet to another worksheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing
Hi, Bob . . .
You nailed it. Thanks for your help! Phil "Bob Umlas" wrote: 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 "Phil" wrote in message ... Does 2007 allow all the page setup settings to be copied from one worksheet to another worksheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing
Note
Print Range and Rows to repeat at top cannot be duplicated on grouped sheets. Gord Dibben MS Excel MVP On Thu, 16 Apr 2009 13:08:00 -0700, Phil wrote: Hi, Bob . . . You nailed it. Thanks for your help! Phil "Bob Umlas" wrote: 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 "Phil" wrote in message ... Does 2007 allow all the page setup settings to be copied from one worksheet to another worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
| Off Set printing | New Users to Excel | |||
| Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
| Printing | Excel Worksheet Functions | |||
| Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Linear Mode
