Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Globally change print settings for several worksheets at the same
I want to change the print settings for several worksheets that are in the
same workbook with one command. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Globally change print settings for several worksheets at the same
Yes, I do it all the time. However, be careful if you need independent modifications and make sure you don't apply those to all of them. Click once on the name for the first worksheet to select it, then hold down Shift and select the last worksheet to which you need to apply the modifications. This will select the first, last and everything in between. If you need to take some out, hold down Ctrl then click on the worksheet that you need to take out. Note that Ctrl + click can be used to select/deselect multiple worksheets individually. -- ArenaNinja ------------------------------------------------------------------------ ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624 View this thread: http://www.excelforum.com/showthread...hreadid=547914 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy page settings to multiple worksheets in excel? | Setting up and Configuration of Excel | |||
How do I copy a worksheet's print parameters to other worksheets? | Excel Worksheet Functions | |||
Print mult worksheets to Adobe | Excel Discussion (Misc queries) | |||
Print Workbook Without Page Breaks Between Worksheets | Excel Worksheet Functions | |||
Macro for changing print settings | Excel Discussion (Misc queries) |