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.
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.
Click the sheet you want to unhide, then click the OK button.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.