unhide sheets

  • Thread starter Thread starter Brian Thompson via OfficeKB.com
  • Start date Start date
B

Brian Thompson via OfficeKB.com

Hi

Is there a way of unhiding multiple sheets without the use of VBA. Using the
function under formating only allows one at a time

thanks in advance

regards
 
Hi Brian

Click on first sheet tab, hold down shift and click on last sheet tab if
they are contiguous, or hold Ctrl and click on separate sheets.
This will group them. Format>Sheets>Hide
 
Roger showed a way to hide sheets.

But you're going to need a macro to unhide more than one at a time.
 
Brian,

The free Excel add-in "Excel Extras" does that and several other things.
It adds a "Unhide All" menu item to the Format | Sheet menu.
You can download it here...
http://www.realezsites.com/bus/primitivesoftware

Regards,
Jim Cone
San Francisco, USA


"Brian Thompson via OfficeKB.com" <u15682@uwe>
wrote in message
Hi
Is there a way of unhiding multiple sheets without the use of VBA.
Using the function under formating only allows one at a time
thanks in advance
regards
--
 
thanks to you all

Jim said:
Brian,

The free Excel add-in "Excel Extras" does that and several other things.
It adds a "Unhide All" menu item to the Format | Sheet menu.
You can download it here...
http://www.realezsites.com/bus/primitivesoftware

Regards,
Jim Cone
San Francisco, USA

Hi
Is there a way of unhiding multiple sheets without the use of VBA.
Using the function under formating only allows one at a time
thanks in advance
regards
Click to expand...
 
Back
Top