Unhiding All Worksheets Within an Excel Workbook

Spreadsheets and graphs on a desk

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.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

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.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.