Note, you can only do this with a VBA macro (there is no shortcut) but it's easy!
Here's how to Create a macro using Microsoft Visual Basic
- On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
- On the Insert menu, click Module.
- Type or copy the code below into the code window of the module.
- If you want to run the macro from the module window, press F5.
- When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.
The code:
Sub UnhideAllSheets()
Dim wsSheet As Worksheet
For Each wsSheet In ActiveWorkbook.Worksheets
wsSheet.Visible = xlSheetVisible
Next wsSheet
End Sub
Dim wsSheet As Worksheet
For Each wsSheet In ActiveWorkbook.Worksheets
wsSheet.Visible = xlSheetVisible
Next wsSheet
End Sub
