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 the worksheets to print, hold down the Ctrl key while you click the sheet tabs of the
worksheets you want to print. Then click the File tab, click Print, and click the Print button.
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 enables you 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 the Print Entire
Workbook option, 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_start workbook located in
your Chapter11 practice file folder to complete this exercise. Open the
SummaryByCustomer_start workbook, and save it as SummaryByCustomer .
Then follow the steps.
1. If necessary, display the Summary worksheet.
2. On the Page Layout tab, click the Page Setup dialog box launcher.
The Page Setup dialog box opens.
3. Click the Sheet tab.
The Sheet page is displayed.