Search

How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)

 

Excel worksheet Row and Column headings are the Column letters at the top of worksheet Columns and Row numbers at the left-side of worksheet Rows.

Excel worksheet Row and Column headings are shown in below image.

Excel Worksheet Row and Column Headers

The Row numbers and Column letters are one of the fundamental features of Excel worksheet. Row number and Column letter combination is used to identify a Cell in Excel worksheet. The Row numbers and Column Letters make it easy for a user to refer Cells inside Excel worksheet.

Sometimes you may need to hide the Row numbers and Column letters to make more space for worksheet area. You can hide Excel worksheet Row and Column headers or show missing hidden Row and Column headers, by following any of below methods.

Method 1 - Hide/Show Excel worksheet Row and Column headings from Excel Ribbon

To hide Excel worksheet Row and Column headings from Excel Ribbon, follow these steps

Step 1 - Click on "View" Tab on Excel Ribbon.

Step 2 - Go to "Show" Group in Ribbon's "View" Tab.

Step 3 - Uncheck "Headings" checkbox to hide Excel worksheet Row and Column headings.

Or

Check "Headings" checkbox to show missing hidden Excel worksheet Row and Column headings, as explained in below image.

 

Hide Show Excel worksheet Row and Column headings from Excel Ribbon

 

As you can see from the below image, Excel worksheet Gridlines is hidden now.

Excel worksheet Row and Column headings Hidden

 

Method 2 - Hide/Show Excel Row and Column headings from "Excel Options" window

Click the following link if you are not familiar with Excel Options Dialog Box Window

You can achieve the same results explained in above method, using "Excel Options" Window.

Follow below steps to hide Excel Row and Column headings or to show missing hidden Row and Column headings.

Step 1 - Open "Excel Options" window from Excel Backstage View.

Step 2 - Open "Advanced" Panel in "Excel Options" window by clicking on it.

Step 3 - Scroll down to "Display options for this worksheet". Make sure relevant worksheet is selected in "Display options for this worksheet" heading.

Step 4 - Uncheck "Show row and column headers" Checkbox to hide Excel worksheet Row and Column headings

Or

Check "Show row and column headers" Checkbox to show Excel worksheet Row and Column headings, as explained in below image.

 

Hide Show Excel worksheet Row and Column headings from Excel Options

 

Step 5 - Click "OK" button in Excel Options window.

 

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook