How to Use the Excel Cell Reference Converter
Excel and Google Sheets identify cell positions in two main ways. The familiar A1 notation uses letters (A, B, C...) for columns and numbers for rows - for example, "C5" means the 3rd column, 5th row. R1C1 notation, on the other hand, uses numbers for both rows and columns in an "R row C column" format. The same position written as R1C1 would be "R5C3".
The two notations serve different purposes. A1 is easier for people to read at a glance and is used in everyday spreadsheet work, while R1C1 makes it easier to calculate column positions numerically, which is why it's common in VBA macros and relative-reference formulas. Once column letters go past Z into two-letter combinations like AA or AB, it's not immediately obvious which column number that is - but in R1C1, it's always a plain number, so the math stays clear.
Column letters run from A=1 through Z=26, and then continue in a base-26-like pattern: AA=27, and so on. Choose a conversion direction, enter a cell reference, and this calculator instantly converts between A1 and R1C1 notation. Excel sheets support up to column XFD (the 16,384th column).
Frequently Asked Questions
A1 notation uses letters (A, B, C...) for columns and numbers for rows (e.g. C5). R1C1 notation uses numbers for both rows and columns, in the format 'R row C column' (e.g. R5C3). R1C1 is often more intuitive when writing VBA macros or relative-reference formulas.
A=1, B=2, ... Z=26, and then it continues in a base-26-like pattern: AA=27, AB=28, and so on. For example, column 'AB' is (1x26)+2 = the 28th column.