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
|
|||
|
|||
how do i change the print settings for an entire wbook in excel?
i wish to assign print properties to my entire workbook with out going
through each worksheet, is this possible? if so how? |
#2
|
|||
|
|||
how do i change the print settings for an entire wbook in excel?
You need to group all the sheets together, then a change on one
worksheet will affect all the others. To do this, right-click on a worksheet tab and click Group all sheets - the tab colour will change to white. Then select File | Page Setup and assign your print properties, including header and footer if you wish. When you are done, make sure that you right click the sheet tab again and Ungroup the sheets. They will now all have the same print properties. Hope this helps. Pete energizerw1 wrote: i wish to assign print properties to my entire workbook with out going through each worksheet, is this possible? if so how? |
#3
|
|||
|
|||
how do i change the print settings for an entire wbook in excel?
Note:
Pete's suggestion is a good one but a couple of limitations to ponder. You cannot set print range or rows to repeat at top when sheets are grouped. Gord Dibben MS Excel MVP On 24 Oct 2006 08:40:29 -0700, "Pete_UK" wrote: You need to group all the sheets together, then a change on one worksheet will affect all the others. To do this, right-click on a worksheet tab and click Group all sheets - the tab colour will change to white. Then select File | Page Setup and assign your print properties, including header and footer if you wish. When you are done, make sure that you right click the sheet tab again and Ungroup the sheets. They will now all have the same print properties. Hope this helps. Pete energizerw1 wrote: i wish to assign print properties to my entire workbook with out going through each worksheet, is this possible? if so how? |
Thread Tools | |
Display Modes | |
|
|