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.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone