• Skip to main content
  • Skip to primary sidebar

Excel Tips and Tricks

  • About
  • Privacy Policy

headers

How to hide row and column headers in Excel

October 19, 2015 by Ravi Leave a Comment

Excel Worksheet by default displays the rows and columns header. For some reason if you want to hide these headers then you can use Excel Advanced Options. Listed below the steps to hide or unhide row and column headers in Excel 2016, Excel 2010 and Excel 2010.

row and column headers in Excel 2013 and Excel 2010

Step 1: Click the File menu and then options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Show row and column headers in Excel 2013 and Excel 2010

Click OK button available at the bottom of the screen to confirm the changes.

 

Excel worksheet without row and column header

Also See: How to hide header/footer while typing in Excel

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Excel 2010, headers, hide, Office 2010

Primary Sidebar

Recent Posts

  • How to increase number of worksheets Excel
  • A trick to flip a column upside down in Excel
  • Prevent users from adding new worksheet in Excel
  • Repeat action keyboard shortcut in Microsoft Office
  • How to import text file in Excel

Copyright 2020 © getexceltips.com