Microsoft Office Tutorials and References
In Depth Information
PRINT MULTIPLE WORKSHEETS
from a workbook
By default, Excel prints either the entire active
worksheet or a selected print area within the active
worksheet. However, you can select several worksheets
and print them all at the same time. You may want to
use this option if you have a workbook with data or
charts on several separate sheets.
To select two or more adjacent sheets for printing,
press and hold the Shift key and click the tab for each
sheet you want to print. To select several nonadjacent
worksheets, press and hold the Ctrl key and click the
tab for each sheet you want to print. To print every
worksheet in the workbook, right-click any tab. A
menu appears. Click Select All Sheets.
Selecting multiple tabs groups the sheets. While the
sheets are grouped, any data you type into any sheet
or any changes you make to the structure of sheets
are also typed into or changed in all the other sheets
in the group. To ungroup sheets, click any unselected
sheet. If no unselected sheet is visible, right-click
any sheet. A menu appears. Click Ungroup Sheets.
Press and hold the Ctrl key.
Click the individual tabs you
want to print.
You can click Chart tabs, Sheet
tabs, and tabs you have
Release the Ctrl key.
The selected tabs appear white.
Click the Page Layout tab.
Click the Page Setup group