Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    drop down from sheet tab? (Excel 2000)

    Hello,

    A collegue of mine brought up that excel worksheet tabs can be clicked on and show a drop down menu.

    I thought that this was impossible but come here to ask is it?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: drop down from sheet tab? (Excel 2000)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> Can't think why, could they mean that if you right click on it a menu pops up <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: drop down from sheet tab? (Excel 2000)

    You can right-click a sheet tab to display a popup menu with several choices applicable to the selected sheet(s).

    You can also right-click the buttons to the left of the sheet tabs to display a popup list of worksheets in the workbook. You can use this to quickly navigate to a sheet, in particular in a workbook with a large number of sheets.

  4. #4
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: drop down from sheet tab? (Excel 2000)

    no he ment a drop down on the sheet tab when you left click on one. so basically he could have all sheets except for one hiding and when he wanted to navigate to another sheet he would pick it from the drop down.

    has anyone heard of this?

  5. #5
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: drop down from sheet tab? (Excel 2000)

    is that limited to newer versions of escel hans?

    can you hide all but one sheet and pick it from this list?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: drop down from sheet tab? (Excel 2000)

    Left-clicking a sheet tab selects the sheet, it doesn't display a dropdown list. Unless your colleague has installed an add-in that adds this capability (I haven't heard of one, and I doubt one exists), he must be mistaken.

  7. #7
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: drop down from sheet tab? (Excel 2000)

    ok, thank you I didnt think it existed.

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: drop down from sheet tab? (Excel 2000)

    It works on my XL2K.
    Legare Coleman

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: drop down from sheet tab? (Excel 2000)

    You can drag the narrow separator on the left hand side of the horizontal scroll bar to the left until only one sheet tab is displayed. Or even none.

Posting Permissions

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