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.
#Unhide a column in excel 2010 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.
#Unhide a column in excel 2010 manual
Now comes a more efficient one, i.e., using Excel Shortcut Key Using Excel Shortcut Key An Excel shortcut is a technique of performing a manual task in a quicker way. 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.