View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O[_2_] Dave O[_2_] is offline
external usenet poster
 
Posts: 19
Default Set print area for entire workbook

"Group" the tabs by holding the CTRL key and clicking each tab
individually or by selecting a tab, holding the SHIFT key, and
selecting another tab (which captures all the tabs in between). Then
perform the print setup: all the selected tabs will carry that setup.

CAUTION! Remember to ungroup the tabs (by right clicking on a selected
tab and clicking Ungroup) before you make other changes, or else any
typing, formulas, etc will appear on all selected tabs.

Enjoy your weekend!