unioncofl.com

Tech, how-to guides, and tutorials based out of Union County, FL

  • Excel 2013
  • About Us
  • Contact
You are here: Home / Excel 2013 / How to Hide a Worksheet Tab in Excel 2013

How to Hide a Worksheet Tab in Excel 2013

August 25, 2016 By Adam

Multi-worksheet workbooks in Excel offer a great solution when you have a lot of information that should be grouped together, but may not necessarily belong in the same spreadsheet. Putting different types of information on different worksheet tabs effectively separates this information, but leaves it easily accessible if you need to reference it later, or if you want to include it in a formula.

If you are using information for a formula on another sheet, then it might be very important that this information is not edited or deleted. One way to accomplish this is to hide the worksheet. This can prevent any accidental edits that might occur by people that inadvertently click the wrong worksheet tab, but leaves it in the file in case that information needs to be edited later. Our tutorial below will show you how to hide, then unhide, a worksheet with an Excel 2013 workbook.

 

How to Hide an Entire Worksheet in Excel 2013

Step 1: Open the workbook containing the sheet that you want to hide.

 

Step 2: Locate the worksheet tabs at the bottom of the window.

locate the worksheet tabs in excel 2013

 

Step 3: Right-click the worksheet tab for the sheet that you wish to hide, then select the Hide option.

how to hide a worksheet in excel 2013

 

If you decide later that you want to unhide this sheet, then right-click on one of the remaining sheet tabs, but click the Unhide option.

how to unhide a worksheet in excel 2013

 

You can then select the hidden sheet that you wish to unhide, then click the OK button.

select the sheet to unhide

 

Are the multi-page spreadsheets that you print difficult to read? One of the most helpful changes you can make is to repeat the top row on every page. This makes it much easier to identify columns on pages 2+ of your worksheet, and helps to prevent confusion that might arise due to neighboring columns containing similar types of data.

Filed Under: Excel 2013

Recent Posts

  • How to Select All of the Cells in a Spreadsheet in Excel 2013
  • How to Horizontally Center a Worksheet When You Print It In Excel 2013
  • How to Remove Decimal Places from a Number in Excel 2013
  • How to Print Gridlines in Excel 2013
  • How to Hide a Worksheet Tab in Excel 2013

Archives

  • January 2017
  • November 2016
  • October 2016
  • August 2016
  • July 2016

Copyright © 2018 unioncofl.com