See all How-To Articles

How to Hide Column and Row Headings in Excel

This tutorial demonstrates how to hide column and row headings in Excel.

 

hide columns and rows headings initial data

 

Hide Column and Row Headings

In Excel, you can hide the numbers at the left of each row and the letters at the top of each column. These numbers and letters are column and row headings. To achieve this, in the Ribbon, go to the View tab and uncheck Headings.

 

hide columns and rows headings ribbon

 

As a result, headings are now hidden.

 

hide columns and rows headings ribbon final

 

Excel Options

Another way to hide column and row headings is to change your Options.

1. In the Ribbon, go to File > Options.

 

hide columns and rows headings excel options

 

2. In the Excel Options window, go to the Advanced tab, uncheck Show row and column headers, and click OK.

 

hide columns and rows headings excel options 2

 

The result is the same as in the section above: Column and row headings are hidden.

 

hide columns and rows headings ribbon final

 

Unfortunately, you can’t do this in Google Sheets.