- #HOW TO UNHIDE ALL SHEETS IN EXCEL HOW TO#
- #HOW TO UNHIDE ALL SHEETS IN EXCEL CODE#
- #HOW TO UNHIDE ALL SHEETS IN EXCEL PLUS#
If you need assistance with adding the VBA module, please refer to this article. You can follow the steps on the screenshot on the right-hand-side. Therefore, right click on any sheet and then click on “Insert” and “Module”. Go to the developer ribbon in Excel (or just press Alt + F11 on the keyboard and skip the next step number two).There is another way of unhiding all hidden and very hidden worksheets: Using VBA. Now run this code, and it will unhide all worksheets except the one named “Workings.Steps for pasting the VBA function to your Excel WorkbookĪgain, this is primarily revelant for older versions of Excel (not Office 365 since beginning of 2021 if you are on the current Excel version please scroll up). Assume you want to unhide all the worksheets except the worksheet named “Workings.” Click on the small green triangle in the top left corner of your spreadsheet. In such cases also we can use VBA Coding. There are situations where we need to unhide all the worksheets except the specific worksheet. Method #5 – Unhide All Worksheets Except Particular Worksheet It will unhide all the hidden worksheets in the workbook. In the new module, paste the copied code.Now insert a new module under the INSERT option.
#HOW TO UNHIDE ALL SHEETS IN EXCEL CODE#
What you have to do is to copy the above code and go to your worksheet, then press ALT + F11 to open Visual Basic Editor. It even facilitates performing the specific activity for every object or value by passing a statement or group of statements in this reference. I have used the For Each loop in VBA For Each Loop In VBA VBA For Each Loop helps the user to inspect and analyze the groups of objects or values individually.Below is the code to unhide all the hidden worksheets in the workbook.įor Each WSht In ActiveWorkbook.Worksheets We can unhide all the sheets by writing the VBA code Writing The VBA Code VBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task. So, how do we unhide all the worksheets once? Unhide window can only unhide single sheets at a time, but imagine you have to unhide 10 sheets, then repeating the same set of tasks 10 times is frustrating. Step 2: This will open the below window.Īs usual, select the worksheet that you want to unhide and click on Ok.Step 1: Just press ALT + H + O + U + H to open the unhide sheet box.Yes, we can unhide the sheet using the shortcut key. See screenshot: Note: You can also right click any one of sheet names in the Sheet tab bar, and select Unhide from the context menu. Now comes a more efficient one, i.e., using Excel Shortcut Key. Step 2: Upon clicking that option, as shown in the above image, we could see the below window.Īs usual, select the worksheet that you want to unhide and click on Ok.Step 1: To unhide single excel sheet go to Home > Format > Hide & Unhide > Unhide Sheet.This method is more tedious than the above one, but it is always a good option to know different techniques. Now, I can see the worksheet named “WS1” in my sheet tab.Select the worksheet that you want to unhide and click on, OK.The Visible property determines the visibility status of a worksheet, as the name suggests.
#HOW TO UNHIDE ALL SHEETS IN EXCEL HOW TO#
#HOW TO UNHIDE ALL SHEETS IN EXCEL PLUS#
There can be three worksheet tabs opened by default, and we can insert more tabs using the plus button. The active tab shows the active worksheet available to edit. To unhide the sheet, we need to right-click any of the worksheet tabs Worksheet Tabs Worksheet tabs in excel are rectangular tabs visible on the bottom left of the excel workbook.