LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repost; Automatically updating formulae in multiple sheets Keith Nicholls Excel Discussion (Misc queries) 1 January 5th 06 03:39 AM
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc EDSTAFF Excel Worksheet Functions 0 November 14th 05 03:27 PM
Time sheets Driver Excel Worksheet Functions 5 November 7th 05 11:19 AM
CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME DEMONET48 Excel Discussion (Misc queries) 2 January 14th 05 08:37 PM
Excel: Enable UnHiding of multiple sheets at once CyberTaz Excel Discussion (Misc queries) 1 January 13th 05 08:30 PM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"