How to display or hide Row & Column Headers in Microsoft 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 with checking or unchecking Headings option

Display or hide Row & Column headings with Excel Options function

Display or hide Row & Column headings with Kutools for Excel

doc-display-hide-headers1
 With Headings

arrow-big

doc-display-hide-headers2
 Without Headings

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

arrow blue right bubble Display or hide Row & Column headings with checking or unchecking Headings option

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

With this method, you can quickly hide and display the Row & Column headings of the current worksheet. Do as follows:

1. Click View tab in the ribbon, and go to the Show group.

2. Then you will see the Headings option, check the Headings option to show Row & Column headings or uncheck it to hide the headings. See screenshots:

doc-display-hide-headers3
-1
doc-display-hide-headers4

arrow blue right bubble Display or hide Row & Column headings with Excel Options function

With this Excel Options function, you can also display or hide Row & Column headings of a selected worksheet.

1. In Excel 2010/2013, click File button, or in Excel 2007, please click doc-office-2007-button button.

2. Then click Options button, and in Excel Options dialog box, go to the Advanced category.

3. Scroll down to the Display options for this worksheet section. You can click the drop down list to choose the worksheet that you want to use. And then check or uncheck the Show row and column headers option according to your needs. See screenshot:

doc-display-hide-headers5

With the above two methods, you can only hide or display the headings for one worksheet, but if you want to show or hide the headings of all worksheets at once, how could you do?


arrow blue right bubble Display or hide Row & Column headings with Kutools for Excel

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

With Kutools for Excel’s Toggle Settings tool, you can quickly show or hide the headings of active worksheet or all worksheets.

1. Click Kutools > Show/Hide > Toggle Settings, see screenshot:

doc-display-hide-headers6

2. In the Toggle Settings dialog box, check or uncheck the Row & Column Headers option, if you check it, it will display the row and column headings immediately in active worksheet, and vice versa. And if you want to apply this operation to all worksheets, you can click Apply to all sheets button. See screenshot:

doc-display-hide-headers7

The Toggle Settings 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…


Related articles:


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh