View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Setting print options globally ?

You can "group" the tabs by holding the CTRL key and individually
right-clicking each tab, or by clicking the left-most tab, holding the
Shift key, and clicking the right-most tab to select all visible tabs.
When tabs are grouped, any change made to any one tab is reflected in
all the tabs. Once grouped you can set your desired print parameters.
Note that hidden tabs are not affected. When you are done setting
print parameters, be sure to un-group the tabs by right-clicking any
tab once and selecting "Ungroup"- if you don't, any typing or shading
or deleting or whatever done on one tab is repeated on all the selected
tabs- easy to destroy data this way. (Bitter voice of experience
talking!)