Microsoft Office Tutorials and References
In Depth Information
To Name and Print Sections of a Worksheet
Print
dialog
box
Loan_Payment
range selected
3
Click Loan_Payment in the
Name list to select the
range B1:E6.
Click the Offi ce Button and then
click Print on the Offi ce Button
menu to display the Print
dialog box.
When Excel displays the Print
dialog box, click Selection in the
Print what area (Figure 4–53).
Selection option
button selected
Figure 4–53
4
Click the OK button
to print the Loan_
Payment range.
Loan Payment
(B1:E6)
One at a time, use
the Name box to
select the names
Interest_Schedule,
Amortization_Schedule,
and All_Sections, and
then print them follow-
ing the instructions in
Step 3 (Figure 4–54).
Interest
Schedule
(B7:E23)
Amortization
Schedule
(G1:K23)
5
Click the Save button on
the Quick Access Toolbar
to save the workbook
using the fi le name,
Braden Mortgage Loan
Payment Calculator.
Why does the All_Sections
range print on one page?
Recall that the Fit to option
was selected earlier
(Figure 4–47 on page
EX 307). This selection
ensures that each of the
printouts fi ts across the
page in portrait orientation.
All Sections
(B1:K23)
Figure 4–54
Other Ways
1. Select cell or range, on
Formulas tab on Ribbon, click
Defi ne Name button, [type
name], click OK button
2. Select cell or range, on
Formulas tab on Ribbon, click
Name Manager button, click
New, [type name], click OK
button, click Close button
 
 
Search JabSto ::




Custom Search