Postingan
A Microsoft Excel workbook is actually a container, a bit like a folder. Each Excel workbook can contain one or more worksheets and it is the worksheet that is the actual container of information. Worksheets are identified by a tab which bears the name of the sheet. Clicking a tab activates that particular sheet.
In exactly the same way that Excel allows you to hide columns and rows, it is also possible to hide entire worksheets. Hiding a worksheet is particularly useful if your workbook contains a lot of sheets. Naturally, once hidden, worksheets can be made visible again by using the Unhide command. It is possible to hide either an single sheet or a group of sheets. However worksheets can only be unhidden a single sheet at a time.
To hide a single sheet, simply right-click on the sheet tab and choose Hide. The corresponding worksheet will then disappear. There is also a ribbon command which will do the same thing. First, highlight the sheet by clicking on its tab and then, in the Cell section of the Home Tab of Excel Ribbon, choose Format-Visibility-Hide and Unhide-Hide.
To hide more than one sheet at a time, simply select the sheets by clicking on the first, holding down the Control key on your keyboard and clicking on each of the others. Next, right-click on any of the highlighted sheet tabs and choose Hide.
To make a hidden worksheet visible once more, you can right-click on any sheet tab and choose Unhide. The Unhide dialog will then appear. Unfortunately, it is not possible to select more than one sheet to unhide; if you try Control-click or Shift-click, you'll soon find that only one sheet can be highlighted. Highlight the name of the sheet that you wish to make visible and click OK.
If you prefer, you can also use the Excel Ribbon command Format-Visibility-Hide and Unhide-UnHide Sheet. When the Unhide dialog box appears, highlight the sheet you would like to unhide and click OK. You will notice that when sheets are unhidden they very conveniently return to the position that they originally occupied.
In exactly the same way that Excel allows you to hide columns and rows, it is also possible to hide entire worksheets. Hiding a worksheet is particularly useful if your workbook contains a lot of sheets. Naturally, once hidden, worksheets can be made visible again by using the Unhide command. It is possible to hide either an single sheet or a group of sheets. However worksheets can only be unhidden a single sheet at a time.
To hide a single sheet, simply right-click on the sheet tab and choose Hide. The corresponding worksheet will then disappear. There is also a ribbon command which will do the same thing. First, highlight the sheet by clicking on its tab and then, in the Cell section of the Home Tab of Excel Ribbon, choose Format-Visibility-Hide and Unhide-Hide.
To hide more than one sheet at a time, simply select the sheets by clicking on the first, holding down the Control key on your keyboard and clicking on each of the others. Next, right-click on any of the highlighted sheet tabs and choose Hide.
To make a hidden worksheet visible once more, you can right-click on any sheet tab and choose Unhide. The Unhide dialog will then appear. Unfortunately, it is not possible to select more than one sheet to unhide; if you try Control-click or Shift-click, you'll soon find that only one sheet can be highlighted. Highlight the name of the sheet that you wish to make visible and click OK.
If you prefer, you can also use the Excel Ribbon command Format-Visibility-Hide and Unhide-UnHide Sheet. When the Unhide dialog box appears, highlight the sheet you would like to unhide and click OK. You will notice that when sheets are unhidden they very conveniently return to the position that they originally occupied.
About the Author:
The The writer of this article is a training consultant with On-SiteTrainingCourses.Com, a UK IT training company offering Microsoft Excel training courses at their central London training centre.
