Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    Annapolis, Maryland, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sticky tab (2003 SP3)

    I've got a spreadsheet with lots of monthly tabs, for which I usually use the current month and maybe the month before, and one other tab that I use all the time. Is there a way to make the one tab always ready to be clicked? It seems like this is something I've seen somewhere before, but I can't canoodle it myself now.

    << | < | > | >> || Summary || March 2008 | April 2008 | et cetera | et cetera | et cetera | et cetera |

    Thanks!
    Michael Coleman
    BOMI International

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

    Re: sticky tab (2003 SP3)

    No, that is not possible.
    However, You can right-click the navigation buttons on the left hand side to get a popup menu listing up to 15 sheets; you can click a name of a sheet to select it. If the number of sheets is large, the popup meni will contain an item More Sheets... that will display a dialog listing ALL sheets.
    You could also place a hyperlink to a specific sheet on the other sheets. That way, the specific sheet would always be only one click away.

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    Annapolis, Maryland, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sticky tab (2003 SP3)

    I thought of using a hyperlink (learned how to do that here in the Lounge years ago) as I was asking the question. I might do that, but the right click thing will do for now. Thanks for the cool trick!
    Michael Coleman
    BOMI International

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: sticky tab (2003 SP3)

    Hyperlinks are Great but I use the below.

    When I work with a large amount of Tabs what I like to do is first go to the far away TAB.

    Now I select the Cell where I want to be in that TAB when I revisit.

    Now Using the Name Box give the Cell the Name AAA

    Anytime you want to revist just go to the Name Box drop down. The first item listed should be AAA just click and your back. You can use AAB for another sheet, etc.

    Makes for easy navagation.

    When done use Insert, Name, Define, and when the Box opens highlight and delete the references.

    Of course the above assumes that you have the Name Box visible on you toolbar.

    Regards,

    Tom Duthie

Posting Permissions

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