You can Unhide all of the sheets in Excel using the following VBA code. Sub UnhideAllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = xlSheetVisible Next ws End Sub Credit to This Website.
In this tutorial you are going to learn how to hide worksheet Excel. This tutorial has been made on Excel 2010 and applies to this versions, as well as 2007.
Step # 1 – Navigating to the Sheet you Want to Hide As you can see here we have a spreadsheet open with the default three sheets available that can be accessed from the bottom. First you need to click on the one that you want to hide, here we are choosing “Sheet 2”. You will be taken to that sheet. Step # 2 – Hiding the Sheet Now, make sure that you are in the “Home” tab from the options at the top.
In the “Cells” area below this click on the “Format” icon. A menu will appear and you need to navigate to “Hide & Unhide”. Click the “Hide Sheet” option to hide the current sheet. It will disappear from the spreadsheet and you will be moved onto the next available sheet, in this case that is “Sheet 3”.
![How to unhide an excel file How to unhide an excel file](https://www.accountingweb.com/sites/default/files/Hide-Unhide-Figure-1.png)
Step # 3 – Making the Sheet Visible Again Now we are going to look at how to make the sheet visible again. Click the “Format” icon again and go back to “Hide & Unhide”. This time click the “Unhide Sheet” option. A dialog box will appear and it will list any sheets that you have hidden, here we can see that that is “Sheet 2”. Click “OK” and the sheet will once again be visible in your spreadsheet and that is how to hide worksheet Excel and then make it visible again.
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 You can hide any worksheet in a workbook to remove it from view. You can also hide the workbook window of a workbook to remove it from your workspace. The data in hidden worksheets and workbook windows is not visible, but it can still be referenced from other worksheets and workbooks. You can display hidden worksheets or workbook windows as needed. By default, all workbook windows of workbooks that you open are displayed on the taskbar, but you can hide or display them on the taskbar as needed. What do you want to do?
Hide a worksheet. Note: If you have a larger number of worksheets that you want to hide, be aware that while you can hide multiple worksheets at once, you can unhide only one sheet at a time. Select the worksheets that you want to hide. How to select worksheets To select Do this A single sheet Click the sheet tab.
If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab. Two or more adjacent sheets Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select. Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the ofShortcutMenu. Tip When multiple worksheets are selected, Group appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. Click Home Format. Under Visibility, click Hide & Unhide, and then click Hide Sheet.
Display a hidden worksheet. Click Home Format.
Under Visibility, click Hide & Unhide, and then click Unhide Sheet. In the Unhide box, double-click the name of the hidden sheet that you want to display.