If Excel shows numbers across the column headings instead of letters, the worksheet is using R1C1 reference style. Turn off that setting to restore the usual A1 headings, such as A, B and C. The steps differ slightly between Windows and Mac.
Change the column headings back to letters
Excel for Windows
- Select File > Options > Formulas.
- Under Working with formulas, clear R1C1 reference style.
Excel will return to A1 style, with letters above columns and numbers beside rows. Microsoft lists these instructions for Excel for Microsoft 365 and Excel 2016–2024. Microsoft’s instructions for showing row and column headings.
As an Amazon Associate I earn from qualifying purchases.
Excel for Mac
- Select Excel > Preferences.
- Under Formulas and Lists, choose Calculation.
- Clear Use R1C1 reference style.
Microsoft lists these steps for Excel for Microsoft 365, Excel 2024 for Mac and Excel 2021 for Mac. Microsoft’s Mac guidance on reference style.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minuteWhat R1C1 means—and why the headings changed
Excel’s default reference style, A1, names columns with letters and rows with numbers. R1C1 names both with numbers: for example, R2C2 means row 2, column 2. It can also express a relative location, such as R[-2]C for the cell two rows above in the same column. Microsoft notes that R1C1 can be useful in macros that calculate row and column positions. Microsoft’s overview of Excel formulas and reference styles.
#1 Best Overall
- Over 215 Microsoft Windows Excel Shortcuts
- Two-Sided Durable Laminiated Sheet
- Designed for Excel on a Windows Computer
This is a reference-style preference, not a change to the worksheet’s data. Microsoft’s fix for numeric column headings is to clear the R1C1 option.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How many rows and columns does Excel have?
In A1 style, Excel’s worksheet columns run from A through XFD, for 16,384 columns, and its rows run from 1 through 1,048,576. Microsoft gives these worksheet limits in its documentation; the page does not state a publication year. Microsoft’s Excel specifications and limits.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
