Although you can quickly hide as many worksheets within a workbook as you like, we’re still limited to unhiding individual worksheets one at a time – unless you’re aware of Excel’s Custom Views feature. Fortunately, there is another way to avoid the agony of manually unhiding worksheets one at a time.
In this article I’ll show you how to use a single line of programming code to unhide the worksheets. Programming code in Excel is often referred to as macros. In this case we’re not creating a permanent macro, but rather typing a line of code to run on demand.
To hide a worksheet, as shown in Figure 1, you can choose Format, Hide and Unhide, and then Hide Sheet on Excel’s Home menu. Or, to save a couple of steps, right-click on the worksheet tab and then choose Hide.
Alternatively, you can also hide multiple sheets at once by holding down the Ctrl key as you click on individual worksheet tabs and then carry out the aforementioned steps. Yet another technique is to select a group of sheets by clicking on the first worksheet tab and then holding down the Shift key as you click on the last worksheet tab within the group. You’ll then hide the sheets as discussed above.
About David Ringstrom, CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.