To switch Excel column headings from letters to numbers in Microsoft 365 for Windows, select File > Options > Formulas, check Use R1C1 reference style, and click OK. This changes the worksheet’s reference display from A, B, C to numbered columns and changes how cell references appear in formulas; it does not change your data.
What the R1C1 setting changes
Excel normally uses A1 reference style: columns have letter headings, rows have number headings, and a cell is named by combining the two. For example, D5 means the cell in column D and row 5. Turning on R1C1 reference style replaces the column letters with numbers. The same cell is then identified as R5C4: R means row, C means column, and the numbers identify row 5 and column 4.
The setting affects how Excel labels cells and writes references, not the underlying worksheet structure. A value in D5 stays in the same place, calculations keep their meaning, and formatting is not removed. Excel still has the same rows and columns; it is showing their positions with a different notation. Row headings remain numbers, so the visible difference is mainly that the column headers are numbered too.
R1C1 is an alternative reference style built into Excel, not a separate add-in or a way to convert column headings into stored numeric data. It can be useful when working with formulas that repeat across a grid, when reading code or documentation that uses R1C1, or when you simply prefer numeric coordinates.
Turn on R1C1 in Excel for Windows
- Open the workbook in the desktop version of Excel.
- Select File, then Options. If a workbook is open, File is on the ribbon.
- In the Excel Options window, choose Formulas.
- Under Working with formulas, select Use R1C1 reference style.
- Select OK to apply the setting.
The column headings should now show numbers instead of letters. If the change is not obvious, look at the top of the worksheet above the grid; the first columns should be labeled 1, 2, 3, and so on. To switch back, repeat the steps and clear the Use R1C1 reference style checkbox.
This is a display and reference-style preference, not a command that rewrites a worksheet into a new format. In desktop Excel, the option is an application-level setting, so a change can affect other workbooks open in that Excel session as well. If you share a workbook, another person’s Excel settings may display its references differently.
Find the setting on Mac or Excel for the web
In Excel for Mac, open Excel > Preferences (called Settings in some releases), choose General, and select Use R1C1 reference style if that option is shown. The precise label or location can vary slightly by Excel release. If you do not see it under General, check Excel’s current settings rather than looking under the Windows-only File > Options menu.
Excel for the web does not provide the same user-facing setting for switching reference styles. If you need to turn R1C1 on or off, open the workbook in the desktop app and use its options. The web version can still be useful for editing the workbook, but do not assume its menus match the Windows or Mac desktop instructions.
How to read R1C1 references
In an R1C1 cell address, the row number follows R and the column number follows C. R1C1 is the top-left cell, equivalent to A1 in the familiar style. R5C4 is D5, while R10C27 is AA10. The R comes first because the notation lists the row before the column, even though a worksheet’s visible column headers appear across the top.
Excel also uses R1C1 notation to express whether a formula points to a fixed position or a position relative to the formula cell. A reference such as R5C4 identifies a specific row and column. Square brackets mark an offset from the cell containing the formula: R[1]C means one row down in the same column, and RC[-1] means the same row and one column to the left. A reference without a number after R or C refers to the formula’s current row or column.
This relative notation is why R1C1 can be helpful in repeated calculations. If a formula is copied across a range, its relative relationship to nearby cells stays consistent. Instead of reading a different letter-based reference in each cell, you may see the same pattern, such as a reference to the cell one column to the left. Absolute and mixed references are represented differently too: the key idea is that a fixed position uses a plain row or column number, while a relative offset is enclosed in square brackets.
What happens to formulas when you switch
Excel displays existing formulas using the selected reference style. It does not normally turn a formula into a different calculation simply because you changed the option. For example, with A1 containing 7 and a formula in B2 referring to A1, the A1-style formula =A1 returns 7. In R1C1 style, that same reference is displayed as =R[-1]C[-1], because A1 is one row up and one column left of B2. The result remains 7.
That change in appearance can be surprising if you expect formulas to keep showing letters. It does not mean the formula is broken: the bracketed values describe the relative position Excel should use. Likewise, switching back to A1 style displays the familiar cell letters again. If a formula actually produces an error after changing the setting, investigate the formula or its input data separately; the reference-style option alone is not a data-clearing operation.
Formulas that use structured table references, named ranges, or functions can still be readable in their own terms. R1C1 changes ordinary cell references, but it does not convert a table’s column name into a number or change the name assigned to a range. When reviewing a complicated formula, check whether each reference is relative, absolute, or mixed before editing it.
Get a column number without changing the headings
You may not need R1C1 at all. If your goal is to use a column’s numeric position in a calculation while keeping the familiar A, B, C headings, Excel’s COLUMN function returns that position. With a formula entered in D2, =COLUMN() returns 4 because D is the fourth worksheet column. The formula can be filled into other columns to return their positions.
You can also ask for the position of a particular cell reference. With D1 as the referenced cell, =COLUMN(D1) returns 4 wherever you put the formula. This can help build a dynamic calculation, label a report with column positions, or check where a range sits. COLUMN returns the worksheet’s numeric column index; it does not change how the worksheet headings look.
These approaches solve different problems. R1C1 changes the reference style Excel uses throughout the worksheet view. COLUMN supplies a number inside a cell while leaving the display style alone. If you only need a number for one calculation or output, a function is usually less disruptive than changing the reference preference for your Excel session.
Limits and side effects to know
Numbered headings do not add columns or alter Excel’s limits. A worksheet still has 16,384 columns: the last column is XFD in A1 notation and column 16,384 in R1C1 terms. Rows also remain numbered, so R1C1 makes both coordinates explicit rather than expanding the worksheet.
Changing reference style can make instructions from other people or online help harder to follow if they use A1 notation. For example, an instruction to select D5 is still understandable as the fourth column and fifth row, but your grid may display that location as R5C4. Formulas copied from a guide may also look unfamiliar, even when Excel evaluates them correctly. Before editing a formula, confirm which style is enabled so you do not mistake a relative reference for a fixed address.
If you use multiple workbooks or regularly collaborate, consider whether changing the global preference is convenient. The workbook’s data and formulas remain usable, but another person may see letter headings because their own Excel setting differs. For a file that will be read by many people, preserving the standard A1 display may avoid confusion; you can still use COLUMN when a numeric index is needed.
Common problems and how to reverse the change
If the headings remain letters after enabling the option, confirm that you selected the checkbox in the desktop app and clicked OK. Also check that you are viewing the intended workbook in that same Excel installation. In Excel for the web, use the desktop app to change the reference-style preference. Closing and reopening the workbook is not normally required, but it can help you confirm which app and setting are in use.
If formulas appear unfamiliar, do not replace their references just to restore letters. Return to File > Options > Formulas and clear Use R1C1 reference style; the worksheet should display A1-style references again. If you intentionally want to keep R1C1, learn the bracket notation and test edits on a copy of a workbook when the formulas are important. Undo is not a substitute for understanding whether a reference is relative or fixed.
When should you use R1C1?
Choose R1C1 if numeric row-and-column coordinates make a large grid easier for you to navigate, if you are comparing formulas copied across many cells, or if a technical workflow specifically uses R1C1 references. Keep A1 style if you follow instructions written with lettered cells, collaborate with people who expect the standard layout, or only need a column index occasionally. For that occasional need, COLUMN is a targeted alternative that does not change the rest of the workbook display.
Frequently Asked Questions
Can I change only one worksheet to R1C1?
The R1C1 option is an Excel application preference rather than a worksheet-level display switch. Changing it can affect other workbooks open in that desktop Excel session, so it is not a reliable way to give just one sheet different column headings.
Does switching to R1C1 change or delete my data?
No. It changes the reference notation and column labels Excel displays. Cell contents, formatting, and the intended results of formulas remain in place. A formula may look different because its references are now written in R1C1 style.
How do I change the column headings back to letters?
On Windows, go to File > Options > Formulas, clear Use R1C1 reference style, and select OK. On Mac, return to the Excel settings where you enabled the option and clear the checkbox.
Is R1C1 the same as numbering columns with a formula?
No. R1C1 changes how Excel labels columns and writes cell references. A formula such as COLUMN returns a numeric result in a cell while leaving the worksheet’s A, B, C headings unchanged.
Why does a formula show brackets such as R[-1]C[-1]?
The brackets indicate a relative offset from the cell containing the formula. R[-1]C[-1] means one row up and one column left. This lets Excel express the same relative relationship in formulas copied to different cells.
Related
- Small Excel Sample Data: Examples to Copy and Use Now
- Large Excel Data: Limits, Tools, and Best Practices
- Large Excel Cheat Sheet Mouse Pad: What to Know
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Conditional Formatting: Can It Hide Columns?No. In Excel for Microsoft 365 on Windows, conditional formatting can change how cells look, but it cannot…
- Where Is the Flash Fill Button in Excel? Find It FastIn Excel for Microsoft 365 on Windows, Flash Fill is on the Data tab, in the Data Tools…
- Delete Blank Rows in Excel: Keyboard Shortcut GuideTo delete blank rows quickly in Excel for Microsoft 365 on Windows, select a column that should contain…
- How to Share a Google Sheets Document SafelyTo share a Google Sheets document, open it in a web browser, select Share in the top-right corner,…
- Basic Excel Table With Data: How to Build and Use OneA basic Excel table with data is a rectangular set of related records organized under a single header…
- Excel Find and Replace Return Character: Line BreaksIn Excel for Microsoft 365 on Windows, use Ctrl+J in the Find what box to search for a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.