In Excel, R1C1 is a cell-reference style that identifies a cell by its row number (R) and column number (C), rather than by a column letter and row number. For example, R1C1 means row 1, column 1—the same cell as A1 in the usual A1 style.
What R1C1 means
Excel can describe the same worksheet cell in two common ways. In A1 style, columns use letters and rows use numbers: A1 is the first cell, and D7 is column D, row 7. In R1C1 style, both coordinates are numbers: R1C1 is the first cell, and R7C4 is the same cell as D7.
The letters are labels, not operators or parts of a formula function. R stands for row, and C stands for column. R1C1 is therefore a coordinate: row 1, column 1. The cell at that coordinate is in the top-left corner of the worksheet.
R1C1 is a reference style, not a separate kind of worksheet or a special calculation feature. Changing the style changes how Excel displays cell addresses and references in formulas. The underlying cells, values, and results remain the same.
How to turn on R1C1 in Excel
In Excel for Microsoft 365 on Windows, select File > Options > Formulas. Under Working with formulas, select R1C1 reference style, then select OK. To return to the familiar letter-based style, go back to the same setting and clear the checkbox.
Excel for Mac has a similar preference, although the wording or location can vary slightly by release. Look under Excel > Settings (or Excel > Preferences in some versions) and then General for the R1C1 reference-style option. Excel for the web generally displays references in A1 style and does not offer the same desktop setting.
This preference affects the way references appear in Excel, not just one selected cell. If a workbook opens and its formulas suddenly look unfamiliar, the R1C1 setting may have been enabled. Switching back to A1 changes their display without changing the calculated answers.
How row, column, and bracket references work
R1C1 references can identify fixed coordinates or describe a position relative to the cell containing the formula. A number without brackets is an absolute row or column coordinate. A number in square brackets is an offset from the formula cell. This distinction is what makes many R1C1 formulas easier to copy and compare.
- R1C1 means row 1, column 1, or A1.
- R7C4 means row 7, column 4, or D7.
- RC means the current row and current column: the cell containing the formula.
- R[-1]C means one row above the formula cell, in the same column.
- R[2]C[1] means two rows down and one column to the right.
Offsets can also mix with fixed coordinates. R1C[1] refers to row 1 in the column immediately to the right of the formula cell. R[-1]C4 refers to the row immediately above in column 4. The brackets apply only to the number inside them; the unbracketed coordinate remains fixed.
For example, if a formula is in D5, R[-1]C points to D4. From that same formula cell, R2C2 points to B2. The first reference follows the formula’s position when copied; the second continues to identify B2.
Reading R1C1 formulas with examples
R1C1 notation is especially useful for seeing how a formula relates to its own cell. Suppose B2 contains 12, C2 contains 8, and the formula is entered in D2. The formula adds the cells one and two columns to the left on the same row:
With the values in B2 and C2 and the formula entered in D2: =RC[-1]+RC[-2] returns 20, because it adds C2 (8) and B2 (12).
If you copy that formula from D2 to D3, the reference pattern remains “the two cells to the left on this row.” In A1 notation, Excel would show a different row number after copying. R1C1 makes the shared relative pattern explicit, which is handy when checking whether a whole column of formulas follows the same logic.
A formula can also point to a fixed coordinate. If B2 contains 12 and you enter the following formula in D5 while R1C1 is enabled, it returns 12:
With 12 in B2 and the formula entered in D5: =R2C2 returns 12, because row 2, column 2 is B2.
These examples use ordinary Excel arithmetic and cell references. R1C1 changes how the references are written; it does not change the meaning of addition or the value stored in a cell.
Why people use R1C1
For everyday editing, many people find A1 easier to scan because column letters are familiar and visually distinct. R1C1 can be more informative when the important question is how far one cell is from another, particularly in repeated formulas.
Common reasons to use it include:
- Comparing copied formulas: Relative offsets make it easier to spot a formula that accidentally refers to a different position from the rest of its column.
- Building formulas in code: Excel VBA offers the
FormulaR1C1property, which lets a macro assign a formula pattern using relative row and column offsets. - Understanding repeated calculations: A formula such as a total that adds the two cells to its left has the same R1C1 pattern wherever it is copied.
- Working with row-and-column logic: Numeric coordinates can be convenient when a task already describes positions as row and column numbers.
R1C1 is not automatically better or faster, and it does not make a workbook calculate differently. It is a different way to express and inspect references. A reader who routinely works with A1 addresses may prefer to keep the default style unless relative offsets or code make R1C1 useful.
R1C1 compared with A1 style
A1 style names a location with a column letter followed by a row number. R1C1 writes the row first and the column second, using numbers for both. For instance, D7 becomes R7C4. In formulas, A1 style commonly shows dollar signs to mark fixed rows or columns, such as a fixed column with a changing row. R1C1 uses brackets to show relative offsets and unbracketed numbers for fixed coordinates.
The styles can make the same formula look quite different. A formula copied down a list may have changing row numbers in A1 style, even though its logic is consistent. In R1C1, a reference to the cell immediately above can remain R[-1]C in every row. That can make repeated patterns easier to compare, while a direct coordinate such as R25C8 may be less immediately readable to someone accustomed to column letters.
Changing the display style does not convert the worksheet into a different format or alter its data. It also does not mean that a reference such as R1C1 is a named range. It is simply Excel’s notation for a worksheet coordinate when the R1C1 style is in use.
R1C1 and Excel VBA
R1C1 is frequently encountered in VBA examples because Excel exposes a FormulaR1C1 property for ranges. A macro can use this property to place a formula whose relative references adapt to each target cell. This is useful when applying one calculation pattern across a range, rather than constructing a separate A1 formula string for every row.
The property name does not mean that every Excel formula must be written in R1C1 style. Excel supports both reference styles in different contexts, and the formula bar display depends on the application setting. If you are reading or maintaining a macro, pay attention to whether it uses Formula or FormulaR1C1; they describe formulas using different reference conventions.
VBA is not required to use the R1C1 setting in the Excel interface. Most workbook users can enable or disable the style through Options, and can continue using ordinary worksheet formulas without writing a macro.
Common problems and misconceptions
The most common surprise is that formulas appear to change after enabling R1C1. In many cases, only the notation has changed: references that previously showed column letters now use row and column numbers. Check the worksheet values and calculated results before assuming a formula was altered.
Another frequent source of confusion is forgetting that brackets mean relative offsets. R[-1]C is not a reference to row negative one; it means one row above the formula cell. Likewise, R1C1 has no brackets, so it identifies a fixed coordinate rather than a relative offset from the current position.
Keep these checks in mind when reading an unfamiliar reference:
- Find the cell containing the formula before interpreting a bracketed offset.
- Read the row coordinate after R and the column coordinate after C.
- Look for brackets to distinguish relative offsets from fixed coordinates.
- If only the display looks different, check the R1C1 preference before editing formulas.
A reference can also be invalid for a particular position if an offset would point outside the worksheet. If a formula copied near the top or left edge refers to a row or column that does not exist, Excel may display a reference error. The same general limitation applies to references in either style.
Frequently Asked Questions
What does R1C1 mean in Excel?
It means row 1, column 1, which is cell A1 in A1 notation. R1C1 is Excel’s alternative reference style, using numbers for both row and column coordinates.
How do I change Excel from R1C1 back to A1?
In Excel for Microsoft 365 on Windows, open File > Options > Formulas and clear R1C1 reference style. On Mac, look for the corresponding option under Excel Settings or Preferences, usually in General.
What does R[-1]C mean?
It means the cell one row above the formula cell, in the same column. The bracketed value is a relative offset, not a worksheet row number.
Is R1C1 a formula or function?
No. R1C1 is a way to write cell references. You can use those references inside formulas, but R1C1 itself does not calculate a result.
Does switching to R1C1 change my formulas or results?
It changes how Excel displays cell references, not the intended calculation or stored worksheet values. If formulas look unfamiliar after switching, interpret the new coordinates before making edits.
Related
- Excel Data Validation Date Picker: Setup and Options
- Excel Data Validation for Dates: Rules and Examples
- Data Validation Checks in Excel: Rules and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add an Automatic Reply to a Shared Mailbox in OutlookTo add an automatic reply to a shared mailbox, open that mailbox in Outlook on the web, then…
- How to Delete Blank Rows in Excel in One Go SafelyTo delete completely blank rows in Excel at once, add a helper column that marks rows with no…
- How to Group Rows in Excel and Collapse Them EasilyTo group rows beneath a heading in Excel, select the detail rows by their row numbers, then choose…
- Create a Signature in Outlook: Step-by-Step GuideTo create an email signature in Outlook, open the signature settings for your version, add and format your…
- 2-Way Data Table in Excel: Setup, Examples, and TipsTo create a two-way data table in Excel, put one set of test values across the top row,…
- Common Excel Shortcut Keys and How to Use ThemThe most useful Excel shortcut keys on Windows include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.