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.
Step 3: Right-click the worksheet tab for the sheet that you wish to hide, then select the Hide option.
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.
You can then select the hidden sheet that you wish to unhide, then click the OK button.
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.