What is R1C1 Notation ? |
This is another way to create cell references which uses numbers for both the rows and columns. | ||
Cell References are displayed in terms of their relationship to the cell that contains the formula rather than their actual position in the grid. | ||
Cells are referred to by relative notation. Absolute references have numbers. Relative references have numbers in square brackets. | ||
The above formulas will be changed to the following when you switch to R1C1 notation. |
 |
Negative row numbers mean that the referenced cell is above the cell containing the formula. | ||
Negative column numbers mean that the referenced cell is to the left of the cell containing the formula. | ||
Changing to R1C1 notation will change all the formulas in that workbook. |
No comments:
Post a Comment