Microsoft Office Tutorials and References
In Depth Information
Printing the Worksheet
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Print a Section of the Worksheet
You can print portions of the worksheet by selecting the range of cells to print and then tapping or
clicking the Selection option button in the Print what area in the Print dialog box. Why? To save paper, you only
want to print the portion of the worksheet you need, instead of printing the entire worksheet. The following steps print
the range A3:E16.
• Select the range to print, cells A3:E16 in this case.
• Tap or click FILE on the ribbon to open the Backstage view.
• Tap or click the Print tab to display the Print gallery.
• Tap or click ‘Print Active Sheets’ in the Settings area (Print tab | Print gallery) to display a list of options that
determine what Excel should print (Figure 2 – 65).
Figure 2 – 65
• Tap or click Print Selection to instruct Excel to print only the selected range.
• Tap or click the Print button in the Print gallery to print the selected range of the worksheet on the currently
selected printer (Figure 2 – 66).
• Tap or click the Normal button on the status bar to return to Normal view.
• Tap or click cell A18 to deselect the range A3:E16.
What are my options for telling Excel what to print?
Excel includes three options to allow you to determine what should be printed (Figure 2 – 65). As shown in the
previous steps, the Print Selection option instructs Excel to print the selected range. The ‘Print Active Sheets’ option
instructs Excel to print the active worksheet (the worksheet currently on the screen) or the selected worksheets.
Finally, the ‘Print Entire Workbook’ option instructs Excel to print all of the worksheets in the workbook.