Paste cell references, ranges or column numbers. The tool detects the format of each line and converts it, including relative references such as R[1]C[-1].
Only used for offsets such as R[1]C[-1]. Enter the cell that holds the formula.
Results4 converted
Convert A1 references to R1C1 notation and back
Excel can name a cell two ways: A1, with a column letter followed by a row number, and R1C1, with a row number and a column number. You run into R1C1 when you read recorded macro code, build text for the INDIRECT function, or switch Excel's reference style in the options.
Paste one reference per line and the converter works out which style each line is in, then returns the other. It handles single cells, ranges, bulk lists and relative offsets such as R[1]C[-1]. A second tab converts column numbers to letters and back.
When you need to switch notation
Reading formulas from a recorded macro
VBA often writes formulas in R1C1 form through the FormulaR1C1 property. Convert the references to A1 to see which cells they point at.
Building text for INDIRECT
INDIRECT reads R1C1 text when its second argument is FALSE. Convert your A1 addresses first so the text you build matches.
Matching a column index to a letter
Scripts and exports often give a column as a number. Look up the letter, or find the number behind a letter such as AK.
Checking a list of references
Paste a column of addresses and scan the results for lines flagged as invalid or outside the worksheet.
How to convert cell references and column letters
- Type or paste cell references or ranges into the box on the Cell Reference tab, one per line.
- Read the results on the right. Each line shows the detected style and the converted reference.
- For offsets such as R[1]C[-1], enter the cell that holds the formula in the Active cell box.
- Switch to the Column Number ⇄ Letter tab to convert a single column or a range such as A:C.
- Copy one result with its copy icon, or use Copy all to get every converted line.
Note: Conversion runs in your browser. The references you enter are not sent to a server.
What the converter accepts and skips
- A range converts at both ends: C10:E20 becomes R10C3:R20C5, and R10C3:R20C5 becomes C10:E20.
- Dollar signs in A1 input are ignored, so A1 to R1C1 results are always absolute (R-number, C-number).
- Offsets such as R[1]C[-1], RC[2] or R[-1]C are resolved from the Active cell, which starts as A1. A result outside the worksheet is rejected.
- A1 style is checked first, so text such as RC5 is read as column RC, row 5. Write R[0]C5 for "same row, column 5".
- Whole-column and whole-row references (A:A, 3:3) are not accepted on the Cell Reference tab. Use the Column Number ⇄ Letter tab for ranges like A:C and 1:3.
- Columns stop at XFD (16,384) and rows at 1,048,576, the size of an Excel worksheet.
Column letter to number chart (A to XFD)
Selected columns where the letters roll over.
| Letter | Number | Letter | Number |
|---|---|---|---|
| A | 1 | Z | 26 |
| AA | 27 | AZ | 52 |
| BA | 53 | ZZ | 702 |
| AAA | 703 | XFD | 16,384 |
XFD, column 16,384, is the last column of an Excel worksheet. The converter handles any column between A and XFD, not only the ones listed here.
R1C1 notation explained: rows, columns, $ signs and brackets
How the two styles name the same cell, and how offsets and absolute references differ.
A1 spells the column, R1C1 counts both
A1 notation puts the column letter first and the row number second. R1C1 writes R for the row and C for the column, each followed by a number. The cell in row 3, column 5 is E3 in A1 notation and R3C5 in R1C1 notation.
How column letters map to numbers
Letters count like a base-26 system with no zero: A to Z are 1 to 26, AA is 27 and ZZ is 702. Three-letter names start at AAA (703) and end at XFD (16,384).
Absolute and relative references in R1C1
In R1C1, plain numbers are absolute: $A$3 is R3C1. Square brackets are offsets from the cell that holds the formula: a formula in B2 that reads =C3 is =R[1]C[1]. Leaving out the number, as in RC[1], means the same row or column as the formula cell.
Where R1C1 shows up
Excel has an R1C1 reference style option under File > Options > Formulas. The INDIRECT function reads R1C1 text when its second argument is FALSE. In VBA, the FormulaR1C1 property reads and writes formulas in this form.
Common R1C1 mix-ups and how to fix them
Reading R5C3 as column 5, row 3
R1C1 puts the row first. R5C3 is row 5, column 3, which is C5, not E3.
💡 See the solution▼
Treating R[1]C[1] as the same cell as R1C1
Brackets make an offset from the formula cell, while plain numbers are fixed. R1C1 is always A1; R[1]C[1] depends on where the formula sits.
💡 See the solution▼
Getting a #REF! error from INDIRECT
INDIRECT returns #REF! when the text is not a valid reference for the style it expects. R1C1 text such as R5C3 only works when the second argument is FALSE.
💡 See the solution▼
R1C1 and column letter questions
Q.What is the difference between A1 and R1C1 notation?
A. A1 notation names a cell by column letter and row number, so column 3, row 5 is C5. R1C1 notation gives the row and the column as numbers, so the same cell is R5C3. Excel uses A1 by default. This converter reads either style and returns the other.
Q.How do I convert a column number to a letter in Excel?
A. Columns run A to Z (1 to 26), then continue with AA (27), AB (28) and so on, so column 52 is AZ and column 53 is BA. Open the Column Number ⇄ Letter tab and type a number from 1 to 16,384 to get the letter. Type a letter instead to get the number.
Q.How do I turn on R1C1 reference style in Excel?
A. Go to File > Options > Formulas and check R1C1 reference style under Working with formulas. Clear the box to switch back to A1. The setting changes how Excel displays formulas.
Q.What does R[1]C[-1] mean?
A. Square brackets mark an offset from the cell that holds the formula, so R[1]C[-1] is one row down and one column to the left. Plain numbers, as in R5C3, are fixed positions. For example, a formula in B2 that reads =C3 is written =R[1]C[1] in R1C1 style. Enter the formula's cell in the Active cell box and the converter resolves offsets from there: with B2 as the active cell, R[1]C[1] becomes C3.
Q.Can it convert ranges and references with $ signs?
A. Yes. A range such as C10:E20 is converted at both ends and becomes R10C3:R20C5. Dollar signs in A1 input are ignored, so $B$2, B$2 and B2 all return R2C2. This means A1 to R1C1 results are always absolute references.
Q.How do I use R1C1 text with the INDIRECT function?
A. Set the second argument to FALSE. For example, =INDIRECT("R5C3", FALSE) returns the value in C5. If the second argument is TRUE or left out, INDIRECT reads the text as an A1 reference.
Q.What are the largest row and column numbers?
A. An Excel worksheet has 1,048,576 rows and 16,384 columns, and the last column is XFD. The converter rejects anything beyond those limits.
Q.Does the converter upload what I type?
A. No. The conversion runs in your browser, and the references you enter are not sent to a server.
Your feedback
makes this tool better.
Tell us which features you'd like, what should be fixed, or which new tool you'd like to see. An engineer reads every submission and uses it to guide development.