1. Home
  2. MS Office

Excel 2010 Remove Row & Column Headers

For sharing out Excel spreadsheets, sometimes you need to hide the main headers to give it more tidy and professional look. In this post we will let you know how to hide the main row and column headers.

Launch Excel 2010 spreadsheet on which you want to hide row and column headers. For instance we have included a spreadsheet which we will be sharing online.

sheet

Now on File menu and click Options.

options

Now from left side bar select Advanced and from right pane scroll down to Display Options for this worksheet section, choose sheet on which you want to apply settings. Disable Show row and column headers option. Click OK to continue.

excel advance 1

You will see that the row and column headers are removed from the worksheet window.

removed

You can also check out previously reviewed guides on Covert Excel Spreadsheet into Graph Paper & How to Change, Remove and Print Gridlines in Excel 2010.

4 Comments

  1. I need to do the opposite (turn the headers on) for files that have them off by default.
    Is there any way to set Excel so that they are ALWAYS on?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.