Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro security settings excel change back to low | Excel Discussion (Misc queries) | |||
Text boxes Excel 2003 change position in print preview | Charts and Charting in Excel | |||
Excel 2003 Print Issue | Excel Discussion (Misc queries) | |||
Why can't I change the print quality in Excel? | Excel Discussion (Misc queries) | |||
How can I set up Excel XP to print the entire workbook by default. | Setting up and Configuration of Excel |