![]() ![]() Step 1: Open the Excel workbook containing the worksheet that you want to hide. 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. ![]() For all intents and purposes, that sheet still exists – you just cannot see it. 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. ![]() Hiding and Unhiding Entire Sheets 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. In this cases, it is helpful for you to learn how to hide an entire sheet in Excel 2010. 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. 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. Excel 2010 has many formatting options that allow you to customize the way that data is displayed in your spreadsheet.
0 Comments
Leave a Reply. |