To hide row numbers and column letters in Excel for Microsoft 365 on Windows, open the worksheet, select View > Show > Headings, and clear the Headings checkbox. This hides both sets of labels on the current worksheet; it does not delete rows or columns or change the cells’ contents.
Hide the headings in Excel for Windows
The row numbers along the left edge and the column letters across the top are called headings. In the Windows desktop app, use the View ribbon to switch them off:
- Open the worksheet you want to change.
- Select the View tab on the ribbon.
- In the Show group, find Headings.
- Clear the checkbox. The row numbers and column letters should disappear from the sheet.
To restore them, return to View > Show > Headings and select the checkbox. You can make this change while a cell is selected or while a range is highlighted; it is a display setting, not a cell-editing command. If you do not see the Show group, make sure you are on the View tab and that the ribbon is expanded. A compact or collapsed ribbon can hide some controls.
The setting affects the worksheet currently on screen. If a workbook has several sheets, check each one where you want the headings hidden. For example, you might remove them from a polished dashboard while leaving them visible on a data-entry sheet where users need to identify columns.
What hiding row and column headings changes
Headings are visual guides that identify worksheet coordinates. The number 5 marks the fifth row, while column letter C marks the third column. Excel still has those rows and columns after you hide their labels: formulas continue to calculate, data remains in place, and cell addresses such as C5 still exist.
Hiding headings also does not hide the worksheet gridlines. Gridlines are the faint lines separating cells, and Excel has a separate control for them under View > Show > Gridlines. You can hide headings while leaving gridlines visible, hide gridlines while leaving headings visible, or hide both. Those choices create different looks, so check the sheet after changing either option.
Nor does hiding headings conceal worksheet content or protect it. A person can still select cells, edit unlocked cells, use formulas, and inspect data if they have access to the workbook. The control is intended to alter the on-screen presentation, not to provide privacy or security.
Can you hide only row numbers or only column letters?
The standard Headings checkbox controls row numbers and column letters together. There is no separate checkbox in that View control for hiding only the row numbers while keeping the letters, or vice versa. If you clear Headings, both sides of the worksheet lose their labels.
If you need a different appearance, consider whether a visual workaround will meet the need. For instance, you can leave headings on but adjust the zoom or window layout to give a chart more space. You can also create a presentation copy of a workbook and hide headings there, while keeping a working copy with the normal navigation cues. Avoid covering the headings with shapes or white-filled cells: that only obscures the display, can interfere with selection, and does not genuinely change the heading setting.
Hiding a row or column is a different action. Use the row or column context menu to hide particular worksheet data; that hides the selected cells from view, not the coordinate labels for the whole sheet. A hidden row still has a row number in the sequence, and hidden columns still have letters before and after the gap.
Excel for Mac and Excel for the web
In Excel for Mac, the worksheet headings can also be turned off, but the setting may be presented outside the Windows ribbon. In Microsoft 365 for Mac, open Excel > Settings (called Preferences in some releases), choose View, and look for the option to show row and column headings under the window options. Clear it to hide the labels, then close the settings. The precise wording and location can vary with the Mac version.
In Excel for the web, open the worksheet and use the View tab. In the Show area, switch off Headings. If the browser window is narrow, ribbon commands may be grouped or tucked into a menu, so widen the window or inspect the available View controls.
These are display controls, so do not assume that a menu path from one platform will be identical on another. If you cannot find the option, search the View tab or the application’s View settings for Headings. You can also reopen the workbook in the desktop app if the browser layout does not expose the control clearly.
Headings on screen versus headings in print
Turning off on-screen headings does not automatically tell Excel to print row numbers and column letters. Printed headings are controlled separately, and Excel normally leaves them off when printing. If you want them on a printout, use the worksheet’s print settings rather than relying on the View checkbox.
In Excel for Windows, select the worksheet, open Page Layout, and find Sheet Options. Under Headings, select the Print checkbox. The separate View checkbox in that group controls whether headings appear on screen. Check Print Preview before printing, since page scaling, print areas, and page breaks affect what appears on the final pages.
This distinction is useful when preparing reports. You may want a clean, borderless-looking dashboard on screen but still include row and column coordinates on a technical printout. Conversely, you can leave headings visible while working and omit them from the printed report. For a multi-sheet workbook, verify the print settings for each sheet you plan to print.
When hiding headings is useful—and when it is not
Removing headings can make a worksheet feel less like a raw grid and more like a finished interface. It is often reasonable for a dashboard, a chart-focused display, a kiosk view, or a worksheet intended mainly for viewing. If a large chart or map sits near the top-left corner, hiding the labels can also give the display a little more visual space.
However, headings are valuable navigation aids. They help readers identify a cell’s location, follow instructions such as enter a value in D8, and distinguish one field from another. On a shared workbook, hiding them without explanation can make it harder for colleagues to follow training materials, troubleshoot formulas, or communicate which cells need attention.
- Consider hiding them on a presentation sheet where the layout is self-explanatory and cell coordinates are not part of the user’s task.
- Consider keeping them on worksheets used for data entry, analysis, formula review, or collaboration.
- For mixed purposes, keep a clearly labeled working sheet and create a separate presentation sheet with the cleaner display.
Also consider accessibility and user expectations. People who use keyboard navigation, screen magnification, or written cell references may rely on headings to orient themselves. A polished appearance is not always worth making the workbook harder to use.
Common problems and how to fix them
The labels disappeared, but cell lines remain. That is expected if you turned off Headings but left Gridlines enabled. Use View > Show > Gridlines separately if you also want to remove the faint cell boundaries from the screen. Gridline display and heading display are independent.
Only one sheet changed. The control applies to the active worksheet, so select another sheet and repeat the steps if you want the same appearance there. For a workbook with many sheets, check them one at a time rather than assuming the setting is global.
The headings return when the workbook is reopened. Confirm that you saved the workbook after changing the setting. If you are working in a shared or browser-based file, also check that your changes finished syncing. A different copy of the workbook, or a different worksheet, may have its own display state.
You cannot find the Headings checkbox. Confirm you are in the Excel application rather than another spreadsheet program, and open the View tab. On Mac, check Excel’s View settings; on the web, look in the View tab’s Show controls. Ribbon layouts can change when the window is narrow, so some commands may be collapsed.
You expected the setting to hide data. Headings are only the coordinate labels. To hide worksheet content, select the relevant row or column and use its context menu, or use an appropriate filtering or protection feature depending on what you are trying to achieve. Hiding headings is not a substitute for hiding sensitive information or restricting access.
Alternatives for a cleaner worksheet
Hiding headings is one of several ways to make a sheet easier to present, but it is not always the best first step. You can use a suitable zoom level, hide gridlines independently, adjust column widths, or arrange charts and summary cells so that important information is immediately visible. A dedicated dashboard sheet can keep the underlying detail available on other tabs.
If your goal is to guide people through a form, use clear labels in the worksheet itself rather than expecting users to infer meaning from coordinates. For instance, a visible heading such as Monthly sales is more informative than telling someone to look at column F. If your goal is to prevent accidental changes, consider protecting the sheet and unlocking only intended input cells; hiding coordinate labels alone does not stop editing.
When sharing a workbook, briefly explain any unusual display choice. A note such as Use the tabs at the bottom to move between sections or Enter values in the blue cells can help readers who no longer see familiar row and column references. Keep a normal working version if you expect to maintain formulas or diagnose cell-level issues later.
Frequently Asked Questions
Does hiding headings delete rows or columns? No. It only removes the row numbers and column letters from the display. Cells, data, formulas, and worksheet structure remain unchanged.
Can I hide row numbers but keep column letters? Not with Excel’s standard Headings checkbox. It switches both row numbers and column letters on or off together for the worksheet.
Will hiding headings affect formulas or cell references? No. A formula that refers to B4 still refers to B4. The coordinate labels are hidden visually, but Excel continues to use cell addresses as usual.
Does hiding headings hide gridlines too? No. Headings and gridlines have separate controls. Turn off Gridlines from the View tab if you want to remove the faint cell boundaries as well.
Will row numbers and column letters print? Not just because they are visible on screen. Printed headings are controlled separately under Page Layout > Sheet Options > Headings > Print in Excel for Windows.
How do I get the headings back? On Windows or the web, return to the View tab and select Show > Headings. On Mac, turn on the row and column headings option in Excel’s View settings.
Related
- Excel Hide Columns From Certain Users: What Actually Works
- Excel Hide Column Letters? What the Setting Actually Does
- Excel: How to Hide Column Lines and Gridlines on a Worksheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Break Lines: How to View and Remove ThemExcel page break lines mark where worksheet content will be divided across printed pages. To inspect them, choose…
- Power Query Current Date: Get Today’s Date in Power QueryTo get today’s date in Power Query, use the M expression Date.From(DateTime.LocalNow()). It reads the current date and…
- Excel to PowerPoint Linked Cells: How to Link and UpdateTo link Excel cells to a PowerPoint slide in Microsoft 365 for Windows, select and copy the cells…
- Data Validation Studio: Excel Rules, Setup, and LimitsThere is no built-in Microsoft Excel feature officially named Data Validation Studio. In Excel for Microsoft 365, the…
- How to Add a Cover Page in Microsoft Word Step by StepTo add a cover page in Microsoft Word for Microsoft 365 on Windows, open your document, choose Insert…
- Excel Group Rows: How to Add and Use the Drop-DownsTo group rows in Excel for Microsoft 365 on Windows, select the rows using their row numbers, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.