Microsoft Office Tutorials and References
In Depth Information
To Name and Print Sections of a Worksheet
1
If necessary, select the range B1:
E6, click the Name box, and then
type Loan_Payment as the name
of the range (Figure 4–51).
name Loan_Payment
appears in Name box
range B1:E6
selected
Figure 4–51
2
Press the ENTER key.
Select the range B7:E23, click
the Name box, type Interest_
Schedule as the name of
the range, and then
press the ENTER key.
Name box arrow
range B1:K23
Select the range
G1:K23, click the
Name box, type
Amortization_
Schedule as the
name of the range,
and then press the
ENTER key.
range G1:K23
range B7:E23
range B1:E6
Select the range B1:K23, click the
Name box, type All_Sections as
the name of the range, and then
press the ENTER key.
Select cell H22 and then click the
Name box arrow in the formula bar
to display the Name list with the
new range names (Figure 4–52).
Figure 4–52
 
Search JabSto ::




Custom Search