Microsoft Office Tutorials and References
In Depth Information
Apply Absolute and Relative Cell References
11
CHAPTER
EXCEL
Working with Formulas and Functions
Copy Absolute References
1 Enter the formula, including
dollar signs ($) for absolute
addresses as needed.
2 Click the cell containing the
formula you want to copy.
D In the Formula bar, the
formula appears with an
absolute cell reference.
3 Click the Home tab.
4 Click Copy (
).
5 Select the cells where you
want the formula to appear.
6 Click Paste .
E Excel copies the formula to
the selected cells.
F The formula in the selected
cells adjusts only relative cell
references; absolute cell
references remain unchanged.
TIP
When would I use absolute cell referencing?
Use absolute cell referencing to always refer to the same cell in a worksheet. For example, suppose your
worksheet contains pricing information that refers to a discount rate in cell G10. When you create a formula
that involves the discount rate, that formula must always reference cell G10, even if you move or copy the
formula to another cell. In this case, use $G$10. You can also combine absolute and relative references,
creating mixed references that allow either the row or column to change while the other remains static if
you copy the formula.
199
Search JabSto ::




Custom Search