Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2010
    Location
    Essex, UK
    Posts
    48
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Question XL13 - Worksheet tab navigation

    Hi,

    have just upgraded to XL 2013, and I am finding navigating worksheets to be (slightly) harder than under my old XL 2007 because I am missing two buttons!

    In XL 2007, there were four navigation buttons: left and right, and also first and last.
    In XL 2013 the first and last buttons appear to have vanished, leaving only the left and right buttons.

    Where have they gone? I used to use them a lot for navigating big spreadsheets, and find it frustrating to have to click and hold the left or right buttons instead. Or perhaps it's just me, and I need to get used to the new best thing...

    Ta

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I don't have XL2013, but According to http://www.excel2013.info/new-interface/

    The First and last worksheet butttons "have been removed. Studies found that very few people used them so Microsoft has decided to remove these buttons."

    It also indicates that "you can easily get to the first and the last worksheet by:
    "holding down the Ctrl key and clicking the arrow
    "click and hold down the mouse button"

    Steve

  3. #3
    Lounger
    Join Date
    Feb 2010
    Location
    Essex, UK
    Posts
    48
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Aha!
    That was the bit I was missing. That's great - the CTRL-click does what I need. Many thanks.

    Stuart

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

    ..if you had pointed your mouse over the left and right navigation buttons, it would show the message to use CTRL-click to get the first and last sheets!
    You could also try right-clicking on those two navigation buttons: it still brings up a scrollable list of all worksheets to make selection of any sheet easier.

    zeddy
    Last edited by zeddy; 2013-09-03 at 17:29.

Posting Permissions

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