Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
Register  \/ 


How to display or hide Row & Column Headers in Excel?

By default, we can locate cells through worksheets with column heading at the top and row heading at the left. Sometimes, you may want to hide these headings. This article will talk about some tips for displaying or hiding headings in Microsoft Excel.

Display or hide Row & Column headings in active worksheet

If you want to display or hide the Row headings and Column headings in the active worksheet, you can do as follows:

Go to the Show group on the View tab, and uncheck the Headings option to hide the Row & Column headings, while check the Headings option to display the headings. See screenshot:

In our example, we uncheck the Headings option on the View tab, and both row heading and column heading are hidden. See screenshot:

Note: You can also click File (Office Button) > Options > Advanced, and then check or uncheck the Show row and column headers option to display/hide the both row heading and column heading. See screenshot:

One click to hide or show the Ribbon Bar/Formula Bar/Status Bar in Excel

Kutools for Excel’s Work Area utility can maximize the working area and hide the whole Ribbon Bar/Formula Bar/Status Bar with just one click. And it also supports one click to restore hidden Ribbon Bar/Formula Bar/Status Bar. Full Feature Free Trial 30-day!
ad work area 3

Display or hide Row & Column headings in active worksheet or all worksheets

The above method can only display/hide the Row & Column headings in one worksheet at a time. But sometimes, you need to display/hide the Row & Column headings in all worksheets. Display/hide the headings in each worksheet one by one? No, that's too tedious! Here I will introduce Kutools for Excel's View Options utility to batch display/hide the Row & Column headings in all worksheets together.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

1. Click Kutools > Show / Hide > View Options.

2. In the opening View Options dialog box, please uncheck the Rows & column headers option to hide the headings, and then click the Apply to all sheets button and Ok button successively. See screenshot:

(1) For displaying the Row & column headings, please check the Rows & column headers option;
(2) For only displaying/hiding the Row & column heading in active worksheet, please do not click the Apply to All sheets button.

The View Options utility of Kutools for Excel makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scroll bar, Horizontal Scroll bar, Sheet Tab, … etc. It will save your time in looking for these settings when you need to show or hide them. Click to know more

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Demo: display or hide Row & Column Headers in all worksheets

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Related articles:

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Peter Grant · 26 days ago
    Excel used to have a line you could move to show the top few rows permanently when you scrolled down a mass of numerical data.  I have not used Excel seriously for some time and now I find in 365 that this feature is hidden or removed.  I continue to search for alternative ways to restore this feature but have had no luck to date.  Can anyone help please?  Peter

  • To post as a guest, your comment is unpublished.
    hussain · 4 years ago
    2 Open Microsoft Excel 2010 from the Start menu.
    3 Click cell D9.
    4 Click the part of the workbook designed specifically for entering formulas.
    5 Bold the selected cell.
    6 Open the area where you can access the Save command.
    7 Select row 1.
    8 Change the font color of the selected cells to the Red, Accent 2 color (from the theme colors).
    9 Apply conditional formatting to the selected cells so each cell appears with a flag icon representing the value of the cell. Do not use the Rules Manager.
    10 Show the numbers at the left of each row and the letters at the top of each column.
  • To post as a guest, your comment is unpublished.
    Eddie Kumar · 5 years ago
    One sheet had lost the Column-header-letters (in one of our PCs), and even after trying all this header-letters where missing, it turned out that it was (somehow) hidden, all I did is selected first few rows and (right-click) clicked unhide and voila. hope this helps others.
  • To post as a guest, your comment is unpublished.
    John Abate · 6 years ago
    How to display or hide Row & Column Headers in Microsoft Excel?
  • To post as a guest, your comment is unpublished.
    Finstar · 6 years ago
    Hi all, please help. At the heading, I always use as Column A, B, C,.. but now it change to Column 1, 2, 3,.. how to change it back? Thanks in advance! :)
  • To post as a guest, your comment is unpublished.
    Frank · 7 years ago
    I'm trying to unhide column A (and/or row 1)in a spreadsheet. Can you direct me to the help page to do this?
    • To post as a guest, your comment is unpublished.
      Chris · 7 years ago
      Hey Frank. Hold Control + G to bring up the "Go To" window. Type "A1" in the Reference box and hit OK. You won't see the active cell, but it's there. Then on the Home ribbon, select Cells > Format, scroll down to Visibility, then select Unhide columns (or rows if the row is hidden too). That should make the column/row available for viewing.
      • To post as a guest, your comment is unpublished.
        Andre · 5 years ago
        Thanks! worked perfectly after my disappearing column would not become visible using other methods discussed.
  • To post as a guest, your comment is unpublished.
    MARTYN · 7 years ago
    WHEN SORTING IN AN EXCEL shreadsheet I use the a to z or the z to a, which worked perfect. now for some reason the column marked "A" will not sort ive since found out that the sequence of letters one is missing ..
    for example I highlight "C" to sort they all sort except "A" when I look the sequence across the top goes...a.c.d.e.f.g.h.i. etc no "b" how do I change so they all run in sequence??