Excel: Hide Column Headers Without Hiding Data

How-to basics · Updated November 19, 2026

To hide the A, B, C column letters in Excel for Microsoft 365 on Windows, open the worksheet and select View > Show > Headings to clear the checkbox. This also hides the row numbers; it does not hide or change any cell data. If by column headers you mean labels such as Product or Date in a table, those are a different feature.

What Excel means by column headers

The phrase column headers can refer to two things in Excel. The first is the worksheet headings: the letters above the grid that identify columns, such as A, B, and C. The row numbers along the left edge are part of the same headings display. Excel’s built-in setting shows or hides both together; it does not offer a separate switch for column letters alone.

The second meaning is the content in cells at the top of a data range. A worksheet might have labels such as Customer, Region, and Total in row 1, or an Excel table might have a dedicated header row. Those labels are ordinary worksheet content or table headers, not the A, B, C headings. Hiding worksheet headings will leave those labels visible.

It helps to identify which one you want to remove before changing the view. If you want a cleaner-looking sheet while retaining the data labels, hide worksheet headings. If you want to remove the labels above a table, use the table’s Header Row setting instead.

Hide the worksheet column letters and row numbers

In Excel for Microsoft 365 on Windows, use the ribbon on the worksheet you want to change:

  1. Select the worksheet tab at the bottom of the workbook.
  2. Open the View tab.
  3. In the Show group, clear Headings.

The letters and row numbers disappear, while the worksheet grid remains. The cells do not move, and their contents, formulas, formatting, and references are unaffected. For example, a formula that refers to B4 continues to refer to B4 even when the B heading is not displayed.

To bring the headings back, return to View > Show and select Headings. If you have several worksheets, check each one: this is a worksheet view setting, so changing it on one sheet does not necessarily change the others. Save the workbook if you want the display choice to be retained when you reopen it.

What the setting changes—and what it leaves alone

Hiding headings changes how the worksheet is displayed, not its underlying structure. Column letters are still used to identify locations in formulas, name definitions, and many Excel commands. Row numbers likewise remain part of the worksheet even though their labels are out of sight. You can still select cells, enter data, calculate formulas, sort ranges, and save the workbook.

The setting is not a way to conceal information. Anyone with access to the workbook can turn headings back on, and the cell contents remain visible. It also does not protect formulas or prevent someone from editing cells. If the goal is to limit editing, use appropriate worksheet protection; if the goal is to keep sensitive information private, do not include it in a workbook shared with people who should not see it.

Hiding headings can make a dashboard or presentation sheet look less like a grid and more like a finished report. For a working data sheet, however, the letters and numbers are useful navigation cues. They help readers identify a location such as C12, follow instructions, and understand formula references.

Hide a table’s header row instead

If your meaning of column headers is the row of labels at the top of an Excel table, use the table controls. Click a cell inside the table so the Table Design tab appears, then clear the Header Row checkbox in the Table Style Options group. The table’s displayed header row is removed from view, but this does not hide the worksheet’s A, B, C letters or its row numbers.

A table header row is useful because it names each field and supports table features such as filtering. When you turn off Header Row, the table remains a table, but people may find its fields harder to interpret and its controls less apparent. Turn the option back on to display the headers again. If the labels are just in a normal range rather than an Excel table, there is no table Header Row checkbox; you would need to hide the worksheet row containing those labels or change the layout.

There is an important distinction between hiding a table header and deleting its text. Clearing Header Row is a display choice for the table. Deleting the labels from their cells changes the worksheet content and can make a data range less understandable or interfere with how a table identifies its fields. Prefer the display option when you only want a cleaner view.

Hide a specific worksheet column or a row of labels

You can hide one or more actual worksheet columns without hiding all worksheet headings. Select the column letter or letters, right-click the selection, and choose Hide. The cells in those columns are no longer displayed, and the visible column letters skip over the hidden columns. For instance, hiding column B makes the next visible letter after A be C. To show it again, select the columns on both sides of the hidden one, right-click, and choose Unhide.

This is different from clearing View > Show > Headings. Hiding column B hides the column’s contents from ordinary view as well as its letter. Hiding worksheet headings keeps the contents of column B visible but removes the letters for all columns. Neither approach deletes the data, so do not treat either as a privacy measure.

To hide a row that contains labels, select its row number, right-click, and choose Hide. This hides the entire row, including every cell in it, rather than just the text labels. If you hide row 1 to remove labels, values in that row are also out of sight. Use this only when the whole row can be hidden without obscuring information readers need.

Keep worksheet headings out of printed pages

The on-screen Headings setting and the print setting are separate. If you want to print the worksheet without the A, B, C letters and row numbers, open Page Layout and find the Sheet Options group. Under Headings, clear the Print checkbox. The View checkbox in that group controls whether headings appear on screen; it is distinct from Print. Check Print Preview before producing a paper copy or PDF to confirm the result.

Excel does not normally print worksheet row and column headings unless that print option is enabled. Therefore, turning off headings on screen is not required just to keep them off a printout. Conversely, hiding them on screen does not by itself tell you whether a particular print setup includes them; inspect the Print checkbox and preview.

Print Titles are another feature and are easy to confuse with headings. Print Titles lets you repeat selected worksheet rows or columns on multiple printed pages. It does not control the A, B, C letters or the row numbers. Use the Headings print option for those labels, and use Print Titles when you want column names or other content rows repeated on subsequent pages.

Excel on Mac and Excel for the web

In Excel for Mac, select the worksheet, open the View tab, and use the Headings option in the Show group if it is available in your ribbon layout. The wording and arrangement can vary slightly by release, but the setting has the same purpose: it hides both worksheet column letters and row numbers. You can also look under Page Layout for the separate View and Print controls in Sheet Options when managing how headings appear on screen or on paper.

In Excel for the web, open the workbook in the browser, select the worksheet, and look on the View tab for the Headings control in the Show area. Selecting it changes the worksheet display; it does not remove data or table labels. The browser ribbon can differ from the Windows desktop ribbon, and some layout controls may be arranged differently. If you cannot find a needed print option in the web interface, open the workbook in the desktop app and adjust the Page Layout sheet settings there.

In all versions, the key question is whether you mean worksheet headings or data labels. The A, B, C letters and row numbers are navigation headings. Names such as Item, Month, and Amount are cell contents or table headers, and require a different change.

Common problems and how to fix them

  • The column letters disappeared, but the row numbers did too. That is expected: Excel’s Headings control affects both sets together. There is no separate built-in toggle for only the column letters.
  • The labels above my data are still showing. Those are probably cell contents or a table header row. Use Table Design > Header Row for a table, or change the relevant worksheet row if the labels are in a regular range.
  • The option changed one sheet but not another. Select the other worksheet and check its Headings setting. A workbook can have multiple sheets with different display choices.
  • The headings still appear on paper. Check Page Layout > Sheet Options > Headings > Print, then confirm the result in Print Preview. The screen and print controls are separate.
  • I hid a column and cannot find its data. Look for a gap in the column letters, select the columns on both sides of the gap, and choose Unhide from the right-click menu.

If the Headings control is unavailable or you cannot change the worksheet, check whether the workbook or sheet is in a restricted editing state and whether you are using a view that limits editing. The exact cause depends on the workbook and Excel version. Also make sure you are on the worksheet you intend to change: a chart sheet, for example, does not have the same cell grid as a regular worksheet.

When hiding headings is a good choice

Hiding headings can be useful for a dashboard, a form-like worksheet, or a report designed for screen viewing. It removes navigation labels that may distract from charts, summaries, or carefully arranged controls. It can also help a worksheet feel less like an unfinished grid when its intended audience is not expected to inspect cell addresses.

Keep headings visible when readers need to navigate, check formulas, follow cell references, or collaborate on a data-heavy sheet. If you hide them, consider adding clear labels within the worksheet itself and explaining how to restore the headings. That makes the file easier to use without relying on users to know where the View setting is.

For most shared workbooks, hiding headings is a presentation decision rather than a data-management decision. Choose it based on how people will use the sheet, and use separate controls for table labels, hidden data, printing, and edit protection.

Frequently Asked Questions

Can I hide only the column letters and keep row numbers?
No. Excel’s worksheet Headings setting controls column letters and row numbers together. You can hide a particular worksheet column, but that also hides its cells and is not the same as hiding only its letter.

Does hiding column headings hide the data?
No. Clearing View > Show > Headings removes the worksheet letters and row numbers from view. Cell values, formulas, and table labels remain in the worksheet.

How do I hide the header row in an Excel table?
Click inside the table, open Table Design, and clear Header Row in Table Style Options. This hides the table’s displayed labels, not the worksheet’s A, B, C letters.

Will hidden headings stay hidden when I print?
Screen display and printing are controlled separately. Check Page Layout > Sheet Options > Headings > Print and use Print Preview to see what the current print settings will include.

How do I show the column letters again?
Select the worksheet, open View > Show, and select Headings. The row numbers return at the same time.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.