Microsoft Office Tutorials and References
In Depth Information
EX 192
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
To Copy Formulas with Absolute Cell References Using the Fill Handle
The following steps show how to use the fi ll handle to copy the January formulas in column B to the other
fi ve months in columns C through G.
Select the range
B5:B16 and then
point to the fi ll
handle in the
lower-right corner
of cell B16
(Figure 3–31).
source area
is B5:B16
mouse pointer
changes to
cross hair
Figure 3–31
Search JabSto ::

Custom Search