View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT YESHWANT is offline
external usenet poster
 
Posts: 41
Default Unhide Multiple Worksheets At Once

Hi Val Steed,

in Excel, you can hid all but one sheets in a workbook in a single stroke
thru :
on the sheet tab, right click and "select all sheets" and the deselect the
sheets which are not to be hidden with regular click of the mouse on
the/those sheets, and then click on format-sheet-hide and your desired
results are achieved.

click yes below, if it helps

"Val Steed" wrote:

How do you unhide mutilple worksheets with one command instead of worksheet
by worksheet?

Val Steed