Rick,

My free Excel add-in "Excel Extras" will do that.
It adds a menu item on the Format menu, next to unhide called "unhide all".
The add-in also does other stuff including sorting sheets in numerical order,
adding a Table of Contents and providing text case options.
Download here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"Rick J" wrote in message...
I have a spreadsheet that has many sheets - each sheet has weekly financial
data that I enter. For convenience, I hide the sheets that have data
already entered. I originally accomplished this by grouping the filled in
sheets then hiding them all at once using the Format | Sheet | Hide menu
item. When I need to review entered data for a particular week I unhide
that particular sheet. The other day I wanted to unhide all the sheets but
I could only manage to do one at a time from the Format | Sheet | Unhide
menu - ouch, very time consuming. Is there a way to do them all at once?
Thanks,
Rick