Microsoft Office Tutorials and References
In Depth Information
Using Mixed Cell References
Did You Know?
You can change an absolute reference back to a relative reference. In
the cell with the absolute formula, repeatedly press F4 until all the dol-
lar signs are removed from the reference. You press F4 to cycle through
all the reference types. For example, if you enter A1 to start a formula,
press F4 to display $A$1. Press again to display A$1. Press again to
display $A1. Press it again to display A1.
Using Mixed Cell References
A mixed cell reference is either an absolute column and relative row or absolute row
and relative column. When you add the $ before the column letter you create an absolute
column or before the row number you create an absolute row. For example, $A1 is abso-
lute for column A and relative for row 1, and A$1 is absolute for row 1 and relative for
column A. If you copy or fill the formula across rows or down columns, the relative ref-
erences adjust, and the absolute ones don’t adjust.
Create a Mixed Reference
Click a cell where you want to enter a formula.
Type = (an equal sign) to begin the formula.
Select the cells you want to use and then complete the formula.
Click the insertion point in the formula bar, and then type $ before the column
or row you want to make absolute.
Click the Enter button on the formula bar, or press Enter.
Search JabSto ::

Custom Search