Hidden worksheets
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Hidden worksheets

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    London
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I hide/un-hide worksheets...

    i.e. open a .xls file but cannot see the worksheet tabs at the bottom, even though there are multiple sheets

    thanks

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    2,314
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you can't see any sheet names go to Tools/Option/View and click "Sheet Tabs"

    to hide and unhide sheets goto: Format/Sheet/Hide or Unhide

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To hide/unhide worksheets goto Format/Sheet/Hide or Unhide.

    If ALL the worksheets tabs are gone then:
    Tools/Options and put a check in "SheetTabs".

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The best way is to set the options to not show worksheets tabs by unticking the box.
    Or you can put the following code
    ActiveWindow.DisplayWorkbookTabs = false
    in the workbook open event

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    For "Hidden" tabs - Go to the "Tools" menu. Select options. On the "View" tab look in the bottom right hand corner. There is a check box next to "Sheet Tabs". Make sure this bok is checked & the tabs should now be visible.
    If you mean that the actual sheet is hidden the go to the "Format" menu, select "Sheet" and then select "unhide". You'll be given a list of sheets that are hidden. Unfortunatley you can only unhide them one sheet at a time.

    HTH

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com