View Single Post
  #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