Microsoft Office Tutorials and References
In Depth Information
To Enter Formulas Using Point Mode and Determine Totals in the Template
5
Select the range
D5:G5 and then
point to the fi ll
handle (Figure 6–13).
range D5:G5
selected
fi ll handle
Figure 6–13
6
Drag down through
the range D6:G11 to
copy the formulas in
the range D5:G5 to
the range D6:G11.
Excel automatically
adjusts the cell refer-
ences so each formula
references the data in
the row to which it is
copied (Figure 6–14).
formulas in range D5:G5
copied to range D6:G11
Figure 6–14
 
Search JabSto ::




Custom Search