Excel: Hide Row and Column Numbers from the Worksheet View

How-to basics · Updated November 19, 2026

To hide row numbers and column letters in Excel for Microsoft 365 on Windows, select the worksheet, open View, and clear Headings in the Show group. This hides the worksheet’s row and column headings, not the cells or their contents; select Headings again to bring them back.

What Excel means by row and column numbers

Excel’s labels along the edges of a worksheet are called headings. Rows are identified by numbers down the left side, while columns are identified by letters across the top: A, B, C, and so on. People sometimes call both sets of labels row and column numbers, but the column labels are letters in the standard worksheet view.

These labels help you locate cells and read references such as B4 or AA12. They are not ordinary worksheet cells, and they are not the same as a heading row that you type into your data. For example, if row 1 contains the labels Product, Quantity, and Price, hiding the worksheet headings does not remove those labels from row 1. It only hides the numbered strip at the left and the lettered strip at the top.

Excel calls the display setting Headings or row and column headers, depending on where you change it. If your goal is to remove the A, B, C and 1, 2, 3 labels from the screen while keeping the worksheet intact, this is the setting to use.

Hide headings on Windows

In the desktop version of Excel for Microsoft 365 on Windows, use the View ribbon tab. The change applies to the active worksheet, so click the intended sheet tab first if your workbook has several sheets.

  1. Open the worksheet you want to change.
  2. Select View on the ribbon.
  3. In the Show group, clear the Headings checkbox.

The row numbers and column letters disappear immediately. The worksheet grid and the cells remain available, and you can still enter and edit data. To restore the labels, return to View and select Headings.

If you do not see the checkbox, the ribbon may be simplified or the Excel window may be narrow. Expand the ribbon or look for the Show group on the View tab. Another route is File > Options > Advanced. Under Display options for this worksheet, choose the relevant worksheet from the list if necessary, then clear Show row and column headers. Select OK to apply the setting. This Advanced option is useful when you want to check which sheet the setting affects.

Excel for Mac and Excel for the web

In Excel for Mac, select the worksheet and look for Headings on the View tab, in the display or show options. Clear it to hide the labels and select it again to restore them. Ribbon organization and wording can vary somewhat between Mac releases, so use the View tab’s worksheet display controls if the group is arranged differently. The Windows path File > Options does not apply to Mac.

In Excel for the web, open the workbook in the browser and use the View tab’s Show options to turn Headings off or on. The available controls can depend on the current interface and editing permissions. If you cannot change the view, check whether the workbook is open in viewing mode rather than editing mode. The web version’s menus are not identical to the Windows desktop ribbon, but the setting has the same purpose: it changes the visibility of worksheet headings.

On Windows, the keyboard shortcut Ctrl+G opens Go To, which can help you navigate after hiding headings; it does not toggle the headings themselves. There is no standard dedicated keyboard shortcut for the Headings checkbox. On Mac, Control+G is commonly used for Go To in Excel, though keyboard behavior can vary with macOS settings. Use the ribbon control when you need to show or hide the labels.

What changes—and what stays the same

Hiding headings is a display change, not a way to hide or protect worksheet data. Excel does not delete rows or columns, change cell values, or alter formulas when you turn off the checkbox. A formula such as =SUM(B2:B10) continues to refer to the same cells, even though you cannot see the B column label or the row numbers at the edges.

Other worksheet features are separate settings. Turning off headings does not automatically turn off gridlines, the formula bar, or the ribbon. It also does not hide a table’s own header row. If the gridlines remain visible, that is expected: use the separate Gridlines option on the View tab if you also want a cleaner, borderless-looking screen. Be aware that removing both headings and gridlines can make it harder to judge cell boundaries.

Some practical ways to work without the labels are:

  • Use the Name Box, to the left of the formula bar, to enter a reference such as D25 and jump to that cell.
  • Use Ctrl+G on Windows to open Go To, then enter a cell address or named range.
  • Use Ctrl+Home on Windows to move to the beginning of the worksheet’s used navigation area, or select a cell by clicking it if its location is apparent.
  • Keep formulas and named ranges as navigation aids; hiding headings does not change their references.

These methods are particularly helpful in a presentation-style sheet or a dashboard where the worksheet edges would otherwise compete with the main content. For routine data entry, however, the labels are useful landmarks and are usually best left visible.

Does the setting apply to one sheet or the whole workbook?

The headings setting is worksheet-specific. Turning it off on one tab does not automatically turn it off on every other tab in the workbook. If you want a consistent appearance across several sheets, activate each sheet in turn and change the setting for each one. You can also select multiple sheet tabs before changing a worksheet view setting, but grouped sheets require care: edits made while sheets are grouped can affect all selected sheets, and it is easy to make unintended changes. Ungroup sheets when finished.

The setting is saved with the workbook, so a recipient may see the same hidden headings when opening the file. If the workbook is shared, consider whether the recipient will need the labels to navigate or understand cell references. Hiding them can make a finished dashboard look less like a working grid, but it can also make a spreadsheet less familiar to someone who needs to inspect or edit its data.

Screen display and printed headings are different

Clearing View > Show > Headings controls the on-screen worksheet view. It does not, by itself, determine whether row numbers and column letters appear on printed pages. Printing has its own setting.

To check printed headings in desktop Excel for Windows, open Page Layout and find Sheet Options. Under Headings, the View checkbox controls on-screen display, while the Print checkbox controls whether headings are included in the printout. Clear Print if you do not want row numbers and column letters on paper or in a print-to-PDF output. Page setup and print controls can be arranged differently on Mac and in the web version; check the sheet’s print or page setup options there rather than assuming the screen checkbox also changes print output.

For a report, it is often more useful to repeat a descriptive table header row on each printed page than to print Excel’s A, B, C and 1, 2, 3 labels. Those are separate choices: worksheet headings identify cell coordinates, while a repeated row contains the meaningful labels you entered, such as Date or Department.

Common problems and misconceptions

The checkbox seems to do nothing. Confirm that the worksheet you intended to change is active, and check whether the headings are already hidden. If you used the Advanced options route, make sure the correct sheet is selected in Display options for this worksheet. A workbook can have different heading visibility on different tabs.

The row numbers disappeared, but the worksheet still has rows. That is normal. Hiding headings does not hide rows. To hide actual worksheet rows, select their row numbers, right-click, and choose Hide; this affects the rows and their contents, unlike the headings checkbox. The same distinction applies to columns. Hidden data can also affect calculations and may be overlooked by readers, so do not use row or column hiding as a substitute for access control.

The letters are gone, but gridlines remain. Headings and gridlines are separate display options. Turn off Gridlines on the View tab if that is also part of the intended appearance. Conversely, if gridlines vanish after changing display settings, check the separate gridline control rather than assuming headings control them.

Headings show on screen but not on paper. Review the Print checkbox under Page Layout > Sheet Options > Headings. On-screen visibility and print visibility are independent. Check print preview before distributing a workbook because page setup, scaling, and print areas can also affect what appears on a printed page.

Frequently Asked Questions

Can I hide only the row numbers or only the column letters?

The standard worksheet Headings control hides or shows the row and column headings together; it does not offer separate checkboxes for the two edges. If you need a customized layout, consider whether a formatted report or dashboard better fits the need, but remember that formatting cells is different from changing Excel’s worksheet headings.

Will hiding headings delete or change my data?

No. It changes what Excel displays along the worksheet edges. Cell contents, formulas, row and column structure, and saved data remain in place. It is not a security feature: people who can access the workbook can still inspect its data.

How do I get the row numbers and column letters back?

On Windows, open View and select Headings in the Show group. On Mac or the web, use the corresponding Headings control in the View tab. If you changed the setting through Windows Advanced options, select Show row and column headers for the desired worksheet.

Why do headings appear on one worksheet but not another?

The display choice is saved per worksheet, so each sheet can have its own setting. Activate the sheet where the labels are missing and turn on Headings. Repeat for other tabs if you want the same view throughout the workbook.

Does hiding headings also remove them from a printout?

Not necessarily. Screen display and printing are controlled separately. In Windows desktop Excel, check the Print option under Page Layout > Sheet Options > Headings, then review print preview to confirm the result.

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.