View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick J
 
Posts: n/a
Default Can I unhide multiple sheets at one time?

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