How to Hide a Sheet in Excel 2010

Excel 2010 has many formatting options that allow you to customize the way that data is displayed in your spreadsheet. If you are working with a large spreadsheet, for example, you may want to hide individual columns and rows so that you are only viewing the data that is relevant to your current task. But, if you are working with a very large Excel workbook that contains a large number of worksheets, then simply hiding a row or column might not help to alleviate your data overload. In this cases, it is helpful for you to learn how to hide an entire sheet in Excel 2010. This will minimize the number of tabs that are displayed at the bottom of your Excel window, allowing you to focus on only the sheets that you currently need.


Hiding and Unhiding Entire Sheets in Excel 2010


The beauty of hiding a sheet as opposed to deleting it is that you do not lose the data contained on that sheet, and it will not break any formulas that rely upon information contained within the sheet. For all intents and purposes, that sheet still exists – you just cannot see it. And once you are done making the changes that required you to hide the sheet in the first place, you can simply unhide it to restore the workbook to its’ original state.


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

Step 2: Right-click the sheet tab at the bottom of the window that you wish to hide.

Step 3: Click the Hide option on the shortcut menu.

how to hide a sheet in Excel 2010


When you decide that you wish to unhide any of of the sheets that you have hidden, you can simply click one of the sheet tabs that is still displayed, then click the Unhide option.

unhide a sheet in excel 2010


Click the sheet you want to unhide, then click the OK button.

choose sheet to unhide


You can also access the Hide Sheet and Unhide Sheet commands from the Format drop-down menu in the Cells section of the Home tab. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.