Excel column headings are letters by default: A, B, C, and so on. If you see numbers across the top instead, the workbook is using the R1C1 reference style; you can switch back to letters in Excel’s formula settings.
What Excel’s column headings normally look like
In the standard A1 reference style, worksheet columns are labeled with letters and rows are labeled with numbers. The first cell is A1, where A identifies the column and 1 identifies the row. The labels across the top are part of Excel’s worksheet interface, not values stored in the cells.
The letters continue after Z rather than stopping at the end of the alphabet. The sequence goes Z, AA, AB, and onward. Excel’s final column is XFD, which is column number 16,384. A worksheet also has 1,048,576 rows, numbered from 1 through 1,048,576.
That letter-based arrangement is why familiar cell references look like C7 or F12. It is Excel’s default, but it is not the only reference style the program supports. The alternative, R1C1, labels both rows and columns with numbers.
Why numbers appear: the R1C1 reference style
R1C1 is a reference style in which R stands for row and C stands for column. With this style enabled, the worksheet’s column headings are numbered rather than labeled A, B, C. For example, what is column A in the usual style is column 1 in R1C1; column B becomes column 2; and column Z becomes column 26.
The name describes how a cell reference is written. In R1C1 notation, R3C2 means row 3, column 2—the same cell as B3 in A1 notation. The row and column numbers in the worksheet frame may therefore look unfamiliar, but they still identify the same grid of cells.
R1C1 can also express relative positions. A reference such as R[-1]C means the cell one row above the formula cell in the same column; R[2]C[-1] means two rows below and one column to the left. The square brackets indicate an offset from the formula’s position. Without brackets, the numbers identify absolute row and column positions.
R1C1 is a built-in Excel option, not a sign that the file is damaged or that the data has changed. It is also used in some programming and technical contexts because numeric row and column positions can make patterns in formulas easier to describe.
How to change numbered headings back to letters
In Excel for Microsoft 365 on Windows, turn off R1C1 reference style in the workbook’s formula options:
- Select File, then Options.
- Choose Formulas in the Excel Options window.
- Under Working with formulas, clear the R1C1 reference style checkbox.
- Select OK.
The headings should return to letters, and cell references in formulas should display in A1 style. To use numbered headings again, follow the same path and select the checkbox.
On Excel for Mac, open Excel > Preferences (or Settings in some releases) > General and look for Use R1C1 reference style. Clear that option to return to letter headings. Menu wording and the location can vary by Mac release, so use Excel’s settings search if the item is not visible. Excel for the web does not provide the same full desktop Options interface; if the setting is unavailable there, open the workbook in the desktop app to change it.
This is a display and reference-style setting, not a command to rename columns or change the worksheet’s data. If you are working in a shared workbook, bear in mind that a change in reference style may affect how formulas are displayed for that workbook, so coordinate with collaborators who rely on a particular notation.
How R1C1 changes cell references and formulas
Changing the reference style changes how Excel presents cell addresses and formulas. In A1 style, a formula might refer to B2:B4. In R1C1 style, the same range is written using row and column numbers. The cells and calculation are the same; the notation is different.
With the numbers 10, 20, and 30 in cells B2:B4, the A1-style formula is =SUM(B2:B4). It returns 60. With the same values in the same cells and R1C1 style enabled, the equivalent formula is =SUM(R2C2:R4C2). It also returns 60 because column 2 is B and the range covers rows 2 through 4.
R1C1’s relative-reference notation can be useful when examining formulas that repeat across many rows or columns. For example, formulas in a filled-down column often refer to the cell immediately above or to another cell a fixed number of positions away. Relative offsets make that relationship explicit, whereas A1 formulas show changing cell addresses as you move down the sheet.
Most people do not need to edit formulas just because the headings switched. Excel translates the displayed references when the style changes. If a formula looks unfamiliar, check the reference-style setting before assuming the formula itself has been rewritten incorrectly.
How numbered columns correspond to lettered columns
Each column has a numeric position whether or not Excel displays it as a number. The first few mappings are straightforward: A is 1, B is 2, and C is 3. After Z, Excel combines letters: AA is 27, AB is 28, and AZ is 52. BA is 53, and XFD is 16,384.
This correspondence matters when reading documentation, code, or instructions that use a different reference style from your workbook. If a guide says to select column 3, for instance, it means column C in the standard lettered layout. Similarly, R1C1 reference R10C4 points to D10 in A1 notation.
- Column 1 = A
- Column 26 = Z
- Column 27 = AA
- Column 52 = AZ
- Column 53 = BA
- Column 16,384 = XFD
The numbers are positions, not a different set of worksheet columns. Switching the reference style does not insert, delete, sort, or move columns. It only changes how Excel labels the grid and represents references.
When R1C1 is useful—and when to choose A1
A1 is the better choice for most everyday spreadsheet work. It is the familiar default, matches many tutorials and examples, and makes it easy to tell at a glance that a formula refers to a recognizable cell such as D15. If you are following instructions that mention lettered columns, using A1 avoids translating between systems.
R1C1 can be helpful for users who work with formulas that follow repeated positional patterns, or who use tools and code that describe cells by row and column number. It can make relative relationships easier to see: the same offset can describe a formula copied across a large block, even though the displayed A1 cell addresses differ from one position to the next.
Choose the style that suits the work and the people sharing the workbook. There is no calculation advantage to switching for a typical SUM or lookup formula, and changing the setting does not make a worksheet more accurate. If you are helping someone who is confused by numbers across the top, restoring A1 is usually the simplest solution.
Common problems and misconceptions
Numbered headings are not the same as data labels in the first row. A worksheet may have text such as Product, Date, or Revenue in row 1; those are cell contents entered by the workbook’s author. The numbered headings above the grid are Excel’s column identifiers. Turning off R1C1 will not change user-entered labels.
Another common misunderstanding is that numbers across the top mean the worksheet has been sorted or that columns were converted into rows. Neither is true. If the grid still has the same contents, changing the reference-style option should restore the familiar display without altering the arrangement.
If the checkbox is already cleared but the headings still seem wrong, check what you are looking at. A table header, chart axis, or row of numbers inside the worksheet is not necessarily the worksheet’s column-heading strip. In the grid, column identifiers sit above the cells, while row numbers sit along the left edge.
If formulas look different after a workbook is opened on another computer, the other user may have a different reference-style preference or may be viewing the file in a different Excel app. Confirm the reference style and inspect the formula bar before editing formulas. Avoid manually replacing references solely because they look unfamiliar; a reference can be valid in either notation.
Frequently Asked Questions
How do I change Excel columns from numbers to letters?
In Excel for Windows, go to File > Options > Formulas and clear R1C1 reference style under Working with formulas. On Mac, look in Excel > Preferences or Settings > General for Use R1C1 reference style.
What does R1C1 mean in Excel?
R1C1 means row and column. A reference such as R4C3 identifies row 4, column 3, which is C4 in A1 notation. R1C1 can also use bracketed numbers to represent positions relative to a formula.
Will switching from R1C1 to A1 change my data or formulas?
No. Excel changes the way it labels columns and displays cell references, not the underlying cell contents or calculation. Still, check formulas if you are collaborating or working with code that expects a particular notation.
Why are the columns numbered in only one workbook?
The R1C1 option may have been enabled while that workbook was active, or the workbook may have been opened with that style in use. Check the formula settings in the desktop app; the setting is not evidence that the workbook’s columns have been rearranged.
Is column 1 the same as column A?
Yes. In R1C1, column 1 is the first worksheet column, which is A in A1 style. The two labels refer to the same position in the grid.
Related
- Data Validation Checklist for Excel: What to Check
- Conditional Formatting in Microsoft Project: What Works
- Data Validation and Verification in Excel Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Written Signature: How to Create and Set It UpTo create a written signature in Outlook, type the name and contact details you want at the bottom…
- Excel Find and Replace Line Breaks in Cells EasilyTo find and replace line breaks in Excel cells, press Ctrl+H, click in Find what, and press Ctrl+J.…
- Compare Two Excel Sheets With Power QueryTo compare two Excel sheets with Power Query, turn each data range into an Excel table, import both…
- Conditional Formatting for Duplicates in ExcelIn Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting > Highlight…
- Schedule Recurring Emails in Outlook: Your OptionsOutlook can schedule a single email, but it does not have a built-in option to send the same…
- Out of Office in Outlook PWA: Set Automatic RepliesTo set an out-of-office message in Outlook PWA, open Settings, find Automatic replies, switch them on, write your…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.