Microsoft Office Tutorials and References
In Depth Information
Apply Absolute and Relative Cell References
EXCEL
chapter 11
Working with Formulas and Functions
Assign Relative References
1 Click in the cell containing the
formula that you want to change.
2 Select the cell reference.
3 Press as many times as
needed to cycle to relative
addressing (that is, remove the
dollar signs).
Note:
2
1
You can press multiple times to cycle
through mixed, relative, and absolute references.
Note:
You can also delete the dollar sign
characters in the Formula bar to make a reference
relative.
4 Press
4
or click Enter (
).
Excel assigns the changes to the
formula.
‚óŹ
When would I use
absolute cell
references?
You use absolute
referencing to always refer
to the same cell in a
worksheet. For example,
suppose your worksheet
contains columns of pricing
information that refer to a discount rate disclosed
in cell G10. When you create a formula that
involves the discount rate, that formula must
always reference cell G10, even if the formula is
moved or copied to another cell. In this case, you
would make cell G10 absolute.
When would I use
mixed cell references?
You use mixed
referencing to reference
the same row or column,
but different relative cells
within. For example,
referencing $C6 keeps
the column absolute
while the row remains
relative. If the mixed reference is C$6, the column
is relative but the row is absolute. You can press
while writing a formula to cycle through
absolute, mixed, and relative cell referencing, or
you can type the dollar signs ($) as needed.
193
 
Search JabSto ::




Custom Search