Only using a macro. One way:

Public Sub UnhideAll()
Dim ws As Worksheet
For Each ws in Worksheets
ws.Visible = True
Next ws
End Sub

If you're unfamiliar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm



In article ,
"Juana Cafe" wrote:

Any way to unhide multipe sheets without going to FormatSheetUnhide for
EACH sheet individually ? I am talking about a very large number of hidden
sheets in multiple workbooks, so a macro would probably not work. Are there
any keyboard shortcuts ?? Excel doesn't offer the Shift+click/Ctrl+click
selection in the Unhide box. Thank you.