![unhide tabs on excel unhide tabs on excel](https://i1.wp.com/www.alphr.com/wp-content/uploads/2021/03/Screenshot_10-2-1.png)
Note: This option does not allow to select multiple hidden worksheets at once. Step 2: You will see a list of all hidden worksheets in the panel.
![unhide tabs on excel unhide tabs on excel](https://www.lifewire.com/thmb/EmJiJtIP8XD4eZsTsjECSC2VZvI=/1598x944/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelRightClickUnhide-5c359e9646e0fb0001114ff3.jpg)
So, it can consume too much time if hidden worksheets are too much. Because it allows to unhide one worksheet at a time. If you the first method to unhide the worksheet, you have to repeat the same steps number of times how many worksheets you want to unhide. The method we discussed above is unhiding one worksheet at a time. In MS Excel, we have methods to unhide worksheets one-by-one or at once. So, you have to unhide all the hidden worksheets to make them visible. Sometimes, more than one worksheet is hidden and you want to work them. Step 7: You will now see that the very hidden worksheet is now visible in the workbook and the hidden worksheet (September) unhide successfully. This option is selected when the sheet is very hidden. If this option is selected, sheet is hidden. If this option is selected, sheet is visible. Step 5: Change the property Visible to -1-xlSheetVisible by choosing it from the corresponding dropdown button. There is an option Properties Window click it to make it visible.
#Unhide tabs on excel code
Tip: If the properties pane is not currently available in VBA code editor, you can enable it yourself. Step 4: When you select the worksheet, its related properties is enabled inside the properties pane below the sheet window. For example, Sheet 2 (August) is hidden here. Step 3: Click the sheet, which is not available (hidden), and you want to unhide it. Step 2: In the right side of the VBA code editor panel, you will see all hidden and unhidden worksheets available in the currently opened workbook. Step 1: Right-click on any of the existing sheet tabs and click on View Code. Follow the steps to unhide the very hidden worksheet. When the worksheet is hidden, it does not display below in the Excel sheet panel. We have an Excel worksheet that is not simply hidden, it is very hidden. From the Excel VBA code editor, users can easily unhide the very hidden worksheet. You require another method to unhide the very hidden worksheet. In that case, simple unhiding method would not work. Unless the simple hidden worksheet, Excel worksheet can also be very hidden.
![unhide tabs on excel unhide tabs on excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2016/04/excel-2013-show-missing-tabs-4.jpg)
You can now see its data and work with it. Step 4: The selected worksheet has been unhide successfully. Step 3: Select the hidden worksheet and click OK. Currently, only one worksheet is hidden, i.e., August. Step 2: You will see the hidden worksheet in the panel. Step 1: Right-click on the existing sheet tabs and click on Unhide option in the list. Here are the simple steps to unhide a hidden worksheet.
![unhide tabs on excel unhide tabs on excel](https://d13ot9o61jdzpp.cloudfront.net/images/unhide_multiple_sheets_custom_view_1.png)
To make the worksheet and its data visible again, unhide the worksheet. When a worksheet is hidden, you cannot see its data.
#Unhide tabs on excel how to
Next → ← prev How to unhide worksheet in Excel?