Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDD
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
ArenaNinja
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy page settings to multiple worksheets in excel? mcwhirter Setting up and Configuration of Excel 1 January 27th 06 03:28 PM
How do I copy a worksheet's print parameters to other worksheets? Redundant908 Excel Worksheet Functions 2 December 6th 05 11:17 PM
Print mult worksheets to Adobe John Day Excel Discussion (Misc queries) 2 May 25th 05 03:54 PM
Print Workbook Without Page Breaks Between Worksheets annem Excel Worksheet Functions 0 December 21st 04 08:05 PM
Macro for changing print settings Bill Excel Discussion (Misc queries) 3 December 3rd 04 10:49 PM


All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"