How to Hide Row and Column Headings in Excel 2010

The numbers and letters at the top and left side of your Excel 2010 spreadsheet are called headings. They are a helpful way to identify your location in a spreadsheet, plus they are also beneficial for ensuring that you are making a change in the correct cell. But, depending upon your current needs, they might not be useful. Luckily you can choose to hide them from view, allowing you to edit your spreadsheet without also having to view this information. If your spreadsheet situation dictates that you need to modify the current settings, you can choose to hide the row and column headings in Excel 2010.


Hiding Excel 2010 Row and Column Headings


While Excel 2010 is typically used as a means or organizing and sorting large amounts of data, you can also use it for other tasks, such as creating forms or creating documents. For tasks like this, the organizational structure of Excel 2010 is not as helpful as it is when you are working with data, so you might wonder how to hide the row and column headings in Excel 2010. This will increase the amount of visible space in your spreadsheet, while also preventing the row and column headings from potentially distracting you.


Step 1: Launch Excel 2010 to open a new spreadsheet, or double-click an existing spreadsheet to open it in Excel 2010.

Step 2: Click the Page Layout tab at the top of the Excel 2010 window.

open excel 2010 page layout menu


Step 3: Locate the Headings column in the Sheet Options section of the horizontal ribbon at the top of the window.

how to hide row and column headings in excel 2010


Step 4: Click the box to the left of View to remove the check mark.

uncheck headings view box


The letter and number column and row headings should now be hidden from view. You can also choose whether to show or hide the headings when the spreadsheet is printing by checking or unchecking the box to the left of Print under Headings. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.