UNHIDE TABS ON EXCEL FOR MAC CODE

Once above code is executed, all the hidden worksheets will become unhidden. In Immediate window, type For each sheet in Thisworkbook.sheets: sheet.visible=true: Next sheet and Hit the Enter key on the keyboard of your computer. On Visual Basic Editor screen, click on the View tab and select Immediate Window in the drop-down menu.ģ. Right-click on any visible worksheet and select View Code option to open Visual Basic Editor.Ģ. While there is no built-in option in Excel to unhide all the worksheets at once, you can execute a simple code in visual basic editor to unhide all the worksheets at once.ġ. Unhide All Worksheets in Excel Using VB Editor Repeat the above steps ( 1~3) to unhide other worksheets.Īs mentioned above, there is no in-built option in Excel to quickly select and unhide multiple or all the hidden worksheets.

Note: You can select only one worksheet at a time.ģ. On Unhide dialog box, select the worksheet that you want to unhide and click on OK. Right-click on any existing or visible worksheet tab and click on the Unhide option.Ģ. If you are only dealing with a few hidden worksheets, you can manually unhide some or all the hidden worksheets by following the steps below.ġ. This will immediately hide all the selected worksheets in the Excel workbook. Once all the Worksheets are selected, right-click on one of the selected worksheets and click on the Hide option. Press & Hold the CTRL Key on the keyboard of your computer and select other worksheets that you want to hide.ģ. Select the first worksheet that you want to hide.Ģ. Hide Multiple Sheets in Excelįollow the steps below to hide multiple sheets in Excelġ. The only way to unhide all sheets at once in Excel is to execute a Visual Basic Command or build a Macro to Unhide Multiple Sheets in Excel. There is really no easy option in Excel to unhide multiple or all worksheets at once. However, you can only Unhide one worksheet at a time in Excel.

Unhide tabs on excel for mac