Page 403 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 67 : Use R1C1 notation

Objectives

At the end of this exercise you shall be able to
• use R1C1 notation in your worksheet.

Requirements
Tools/Materials

• PC/Laptop with Windows OS
• MS Excel 2013 or Higher

Procedure

R1C1 notation is an alternative way of referencing cells in Microsoft Excel, as opposed to the more common A1
notation. In R1C1 notation:
• R stands for Row.
• C stands for Column.
• The numbers following R and C represent the row and column numbers, respectively.
The basic format of an R1C1 reference is R[row]C[column].
For example:
• R1C1 refers to the cell in the first row and first column.
• R2C3 refers to the cell in the second row and third column.
In addition to explicit cell references, you can use relative references in R1C1 notation. For instance:
• RC[-1] refers to the cell in the same row and one column to the left of the active cell/current cell.
• R[2]C refers to the cell two rows below and in the same column.
How to Switch to R1C1 Notation in Excel:
1 Open Excel.

388