Excel guide · 6 min read
Excel row numbers and column letters missing (not showing)
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | What you see | Cause | Fix |
| 2 | No row numbers or column letters on one sheet | Headings turned off for that sheet | View > tick Headings |
| 3 | Other sheets in the file are fine | The setting is per sheet | Tick Headings on each sheet |
| 4 | Columns show 1, 2, 3 instead of A, B, C | R1C1 reference style | File > Options > Formulas |
| 5 | Headings on screen, not on paper | Printing headings is separate | Page Layout > Headings > Print |
| 6 | Not sure which cell you're in | Headings hidden | Read the Name Box left of the formula bar |
| 7 | Can't click a column letter to select it | Headings hidden | Ctrl+Space selects the column anyway |
1. Turn headings back on
The grey bar of letters across the top and numbers down the side are called headings. Hiding them is a deliberate option, often used for dashboards and forms so they look less like a spreadsheet, which is why you mostly meet the problem in a file someone else built.
- Click on the sheet that has no headings.
- Go to the View tab.
- In the Show group, tick Headings.
Excel for Mac and Excel for the web
The box has the same name on the other versions. In Excel for Mac it's on the View tab of the ribbon. In Excel for the web, open the View tab and tick Headings; if the file opened in Viewing mode, switch to Editing first.
Because the setting is saved in the file, ticking it in one version shows the headings in the others too, for that sheet.
Turn headings on for every sheet at once
A workbook with 30 sheets and headings off on all of them means 30 clicks. A one-line macro in the Immediate window does it in one go on desktop Excel for Windows or Mac. Nothing is saved as a macro in the file, so it can stay an .xlsx.
Unhide any hidden sheets first (right-click a sheet tab > Unhide): Excel can't activate a hidden sheet, so the loop stops with an error when it reaches one. Very hidden sheets don't appear in that list; leave them alone unless you built the file.
- Press Alt+F11 to open the VBA editor (on a Mac: Tools > Macro > Visual Basic Editor).
- Press Ctrl+G, or choose View > Immediate Window, to open the Immediate window.
- Paste this line and press Enter: For Each ws In Worksheets: ws.Activate: ActiveWindow.DisplayHeadings = True: Next
- Close the editor. Every visible sheet now shows its row numbers and column letters. Change True to False to hide them all, for a dashboard workbook.
Some row numbers or column letters are skipped
If the headings are there but the numbers jump from 4 to 9, or the letters go A, B, E, the headings are fine: rows or columns are hidden. Hidden rows show as a double line between the numbers on either side. If the skipped row numbers around the gap are blue, a filter is hiding them instead, and Data > Clear (in the Sort & Filter group) brings them back.
Row 1 or column A hidden is the awkward case, because there's nothing above or left of it to select. Type A1 in the Name Box and press Enter, then use Home > Format > Hide & Unhide > Unhide Rows (or Unhide Columns).
One more lookalike: Freeze Panes set while the sheet was scrolled down. The rows above the frozen part can't be scrolled back into view, so the sheet seems to start at row 20. View > Freeze Panes > Unfreeze Panes shows them again; scroll to the top before you freeze again (freeze panes explains which cell to select).
- Click the corner button above row 1 and left of column A (or press Ctrl+A twice) to select the whole sheet.
- Right-click any row number and choose Unhide.
- Right-click any column letter and choose Unhide.
2. Two other places with the same switch
The same setting appears in two more places. They all control one option, so use whichever you find first.
- Page Layout > Sheet Options > Headings > tick View.
- File > Options > Advanced > Display options for this worksheet > tick Show row and column headers. Check that the drop-down next to the heading names the sheet you mean, then click OK.
3. Why it's off on one sheet and fine on the others
Headings are stored with each sheet, inside the file. That has three consequences. Every sheet has its own setting, so fixing one doesn't fix the rest. The setting travels with the workbook: a colleague who opens it sees the same hidden headings, and it isn't a problem with their Excel. And a new blank workbook starts with headings on, unless your organisation's default template turns them off.
If you build dashboards, it's fine to hide headings on the summary sheet. Leave them on the data and calculation sheets, where people need to find cell addresses.
4. Columns show numbers instead of letters
If the headings are there but the columns read 1, 2, 3 instead of A, B, C, headings aren't the problem. The workbook is using R1C1 reference style, and formulas will look like =R2C3 as well. Turn it off with File > Options > Formulas > untick R1C1 reference style. The full fix, and why it happens, is in Excel columns show numbers instead of letters.
5. Printing the row numbers and column letters
Headings on screen never print by default, whatever the View setting. To put them on paper, which helps when someone will write notes on a printout and refer back to cells, tick Print under Headings.
- Go to Page Layout > Sheet Options.
- Under Headings, tick Print.
- Check the result in File > Print before printing. Gridlines have their own Print box next to it.
6. Working without headings
If you can't change the setting (a shared file you shouldn't edit, for example), you can still get around. Ctrl+Space selects the current column and Shift+Space the current row. The Name Box to the left of the formula bar always shows the active cell's address, so you can still see where you are and type an address like D40 to jump there.
If the ribbon or formula bar is missing as well, those have their own settings: see Excel ribbon missing and formula bar missing. For the faint lines between cells, see gridlines not showing.
Common mistakes
Fixing one sheet and expecting the rest to change
Headings are per sheet. Tick View > Headings on each one.
Reinstalling or resetting Excel
It's a setting saved in the workbook, not a fault. Tick Headings; nothing else is needed.
Confusing missing headings with R1C1
If you see numbers across the top, headings are on. Turn off R1C1 reference style in File > Options > Formulas.
FAQ
How do I show row numbers and column letters in Excel?
View tab > Show group > tick Headings. Do it on each sheet where they're missing, because the setting is per sheet.
Why are the column letters missing in Excel?
Headings were turned off for that sheet, usually by whoever built the file. It's saved in the workbook, so everyone sees it. Tick View > Headings to show them.
How do I print row and column headings in Excel?
Page Layout > Sheet Options > Headings > tick Print. Showing them on screen doesn't make them print.
Why do my Excel columns have numbers instead of letters?
That's R1C1 reference style, not missing headings. Untick R1C1 reference style in File > Options > Formulas.
Why are some row numbers missing in Excel?
Those rows are hidden or filtered out. Blue row numbers mean a filter: use Data > Clear. Otherwise select the whole sheet, right-click a row number and choose Unhide. See unhide rows not working for the stubborn cases.
How do I show row and column headings on all sheets at once?
The View > Headings box changes one sheet. For all of them, run For Each ws In Worksheets: ws.Activate: ActiveWindow.DisplayHeadings = True: Next in the VBA Immediate window (Alt+F11, then Ctrl+G), after unhiding any hidden sheets.
Related guides
- Excel columns show numbers instead of letters: how to switch back
- Excel gridlines not showing (or missing in some cells): how to get them back
- Excel ribbon missing: how to get it back
- Excel formula bar missing or not showing: how to get it back
Updated