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.

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.

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

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.

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