In this video, I will show you how to unhide worksheets in Excel (with or without VBA).
In Excel, you can hide multiple worksheets at one go but you can not unhide multiple sheets at one go. If you use the inbuilt functionality to unhide sheets, it will only unhide one sheet at a time.
However, there are a couple of methods you can use to unhide all sheets at one go in Excel.
This video covers the following methods to unhide sheets:
— Manually Unhide one sheet at a time
— Unhide all sheets using VBA code in the immediate window
— Unhide all sheets by using a VBA macro code and adding it to the quick access toolbar
— Unhide sheets using custom view option.
With VBA immediate window, you can quickly run a line of code by simply adding it in the immediate window and hitting the enter key.
Below is the line of code to use in the immediate window in the VB Editor:
For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet
As soon as you hit the enter key (after placing the cursor at the end of the line), it will instantly unhide all the hidden sheets.
The good thing about this is that you don’t need to save the Excel workbook as a macro-enabled workbook.
Another method is by saving a VBA macro code to unhide sheets in the personal macro workbook and then adding that code to the Quick Access Toolbar (QAT)
Doing this would allow you to work on any workbook and instantly unhide sheets with a click of a button.
Below is the VBA code to save in the personal macro workbook:
Sub UnhideAllSheets()
For Each Sheet In Sheets
Sheet.Visible = True
Next Sheet
End Sub
The third method to unhide sheets is by using custom views. You can save a custom view when all the sheets are visible and then when you have to unhide all the worksheets, you can go back to that view.
This method to unhide sheets is not suited in all situations but can be useful if you’re using custom views anyway.
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial