• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

headers

How to hide row and column headers in Excel

October 19, 2015 by Admin 1 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

  • Digital Photography for Seniors: Capturing and Sharing Memories
  • Learning New Skills Online: Websites and Platforms for Seniors
  • How to Use a Password Manager Effectively
  • Social Media Usage Tips and Tricks for a Balanced Life
  • Wi-Fi Optimization Tips and Tricks for Home Users

blogmines.com Copyright © 2023