Microsoft Office Tutorials and References
In Depth Information
Cell and Range References
absolute references to row 2 and column B, each copied formula produces the correct result. If
the formula uses relative references, copying the formula causes the references to adjust and
produce the wrong results.
Figure 2-4: An example of using mixed references in a formula.
A1 versus R1C1 notation
Normally, Excel uses A1 notation. Each cell address consists of a column letter and a row
number. However, Excel also supports R1C1 notation. In this system, cell A1 is referred to as cell R1C1,
cell A2 as R2C1, and so on.
To change to R1C1 notation, choose File➜Options to open the Excel Options dialog box, click the
Formulas tab, and place a check mark next to the R1C1 Reference Style option. Now, notice that
the column letters all change to numbers. And all the cell and range references in your formulas
also adjust.
Look at the following examples of formulas using standard notation and R1C1 notation. The
formula is assumed to be in cell B1 (also known as R1C2).
Standard
R1C1
=A1+1
=RC[–1]+1
=$A$1+1
=R1C1+1
=$A1+1
=RC1+1
=A$1+1
=R1C[–1]+1
=SUM(A1:A10)
=SUM(RC[–1]:R[9]C[–1])
=SUM($A$1:$A$10)
=SUM(R1C1:R10C1)
If you find R1C1 notation confusing, you’re not alone. R1C1 notation isn’t too bad when you’re
dealing with absolute references. When relative references are involved, though, the brackets
can drive you nuts.
continued
 
Search JabSto ::




Custom Search