The best part about this is that you can do this on any workbook. The above steps would instantly unhide all the sheets in the workbook.
#HOW TO UNHIDE ALL SHEETS IN EXCEL FOR MAC CODE#
VB Editor in Excel has an immediate window where you can type a line of code and instantly execute it right away.īelow are the steps to use this above line of code to unhide sheets through immediate window: Note: The methods covered in this tutorial doesn’t require you to save an Excel workbook in a macro-enabled format (.XLSM) to use the VBA code. With VBA, you can easily unhide worksheets in bulk.įor example, if you have 10 hidden worksheets, you can create a simple VBA code to unhide all the worksheets or you can unhide based on a condition (such as unhide only those where there is a specific prefix or year in the name). While there is no-inbuilt functionality to unhide in bulk, you can easily do this with a simple VBA macro code. As of now, you need to use the unhide dialog box where you can only select one worksheet to unhide. Unfortunately, there is no in-built functionality in Excel to quickly unhide all the hidden worksheets (or a way to select more than one worksheet and unhide it). If you want to hide worksheets, you can select multiple worksheets at once (hold the control key and click on the worksheet tab name), right-click and click on the Hide option. You can hide worksheets in bulk, but not unhide in bulk Note: Unfortunately, there is no in-built functionality in Excel to quickly unhide all the hidden worksheets (or a way to select more than one worksheet and unhide it). The above steps would unhide the select worksheet.
In the Unhide dialog box, click on the worksheet that you to unhide (you can only select one at a time).This will open the Unhide dialog box that lists all the hidden worksheets Right-click on any of the existing worksheet tab.Suppose you have an Excel workbook that has 10 worksheets that are hidden.īelow are the steps to manually unhide worksheets (one at a time):
If you only have a few worksheets that are hidden, you can manually unhide some or all of these worksheets. Unhide All or Selected Sheets Using Custom View.Unhide Selected Sheets (Based on User Selection).
Unhide Sheets With Specific Text in the Name.By Adding Macro to QAT (with One Click).