You'd need a macros to do that

Sub RevealSheets()
Dim mySht As Worksheet
For Each mySht In ActiveWorkbook.Worksheets
mySht.Visible = True
Next mySht
End Sub


Regards,

Peo Sjoblom

"ahonig" wrote:

I'm working in a workbook with multiple hidden sheets. I have to unhide all
of them and delete most of them. It's time consuming doing this individually
and I can figure out how to unhide all of them at once. The control and
shift keys do not work with this function. How can I unhide all my hidden
sheets at the same time?