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? |
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? |
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? |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com