Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I unhide multiple sheets at one time?
Rick, here is one way with a macro
Sub unhide_all_sheets() Dim ws As Worksheet For Each ws In Worksheets ws.Visible = True Next ws End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I unhide multiple sheets at one time?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I unhide multiple sheets at one time?
Paul and Jim - Thanks for the quick response. Jim, I'll check out your
addin. Rick "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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repost; Automatically updating formulae in multiple sheets | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Time sheets | Excel Worksheet Functions | |||
CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME | Excel Discussion (Misc queries) | |||
Excel: Enable UnHiding of multiple sheets at once | Excel Discussion (Misc queries) |