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.

Advertisement
  • http://www.facebook.com/drofidnas Chris Sandiford

    How do you remove them independently? Excel 2003 had that option.

  • Katy

    There needs to be a shortcut to show/hide the headers.