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!
|