Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Northwood Hills, Middlesex, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Amending Worksheet Tab Titles (2000)

    I know XP can have 'coloured' (sic - I'm english!) tabs - but have been advised that you can also 'redirect' the tabs so that more titles are visible at the same time (rather like the 'alignment' feature for cell direction. I've not been able to find out how) - Does anyone know if it is possible?, and if so how it is achieved. Ideally I'd like to use it on my machine running Office 2000, but I have access to XP also.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Amending Worksheet Tab Titles (2000)

    Do you mean by grabbing the tab split bar just to the right of visible tabs and just to the left of the horizontal scroll bar, and dragging it over to the right? There is also the alternative of seeing all sheet names in a pop-up box by right-clicking the Sheet Movement "VCR" buttons/arrows over on the left. If there's something else, I'm interested myself!
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Amending Worksheet Tab Titles (2000)

    Hi,
    If you mean having the tab text vertical or at an angle, then no, not that I've discovered. It's a nice idea though!
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Re: Amending Worksheet Tab Titles (2000)

    If ou right-click your mouse in the button area immediately to the left of the first tab you will see a vertical list of all your sheets (scroll list if you have dozens!)

    zeddy

Posting Permissions

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