Microsoft Office Tutorials and References
In Depth Information
If you want to print more than one worksheet from the active workbook, but not every
worksheet in the workbook, you can select the worksheets to print from the tab bar. To
select specific worksheets to print, hold down the Ctrl key while you click the sheet tabs of
the worksheets you want. Then display the Backstage view, click Print, and click the Print
TIP The worksheets you select for printing do not need to be next to one another in the
One helpful option on the Sheet page of the Page Setup dialog box is the Cell Errors As
box, which you can use to select how Excel will print any errors in your worksheet. You can
print an error as it normally appears in the worksheet, print a blank cell in place of the error,
or choose one of two other indicators that are not standard error messages.
After you prepare your workbook for printing, you can specify which elements to print
by displaying the Print page of the Backstage view and then clicking the Print What
button, which displays Print Active Sheets by default. To print the entire worksheet, verify
that the Print What button displays Print Active Sheets, and then click the Print button. To
print every worksheet in the active workbook, click the Print What button, click Print Entire
Workbook, and then click the Print button.
In this exercise, you’ll print nonadjacent worksheets in your workbook and suppress errors
in the printed worksheet.
SET UP You need the SummaryByCustomer workbook located in the Chapter11
practice file folder to complete this exercise. Open the workbook, and then follow the steps.
If necessary, display the Summary worksheet.
On the Page Layout tab, click the Page Setup dialog box launcher to open the Page
Setup dialog box.
Click the Sheet tab to display the Sheet page of the dialog box.