A reference system where both rows and columns are identified by numbers instead of the standard A1 column-letter format.
Yapay zekâ ile deneIn R1C1 style, 'R' stands for Row and 'C' stands for Column, followed by their respective numeric indices. This style is particularly useful for calculating relative positions in macros and VBA, as it allows for consistent reference patterns across different parts of a worksheet.
In R1C1, the cell at row 2, column 3 is referred to as R2C3, whereas in A1 style it is C2.
Go to File > Options > Formulas, then check or uncheck the 'R1C1 reference style' box under 'Working with formulas'.