TechSpot

Sheet tab scroll buttons don't work on Excel 2010

By abbasi
Apr 19, 2014
Post New Reply
  1. In my Excel 2010 file there are three sheets. I can navigate between them by clicking on the sheets on the bottom left hand side, next to Sheet tab scroll buttons.

    But I can't use "Sheet tab scroll buttons" because when clicking on them they don't do anything. I don't know what is the problem.

    Is there anyone who knows the reason please?
     
  2. Rabbit01

    Rabbit01 TS Booster Posts: 902   +39

    You talking about these in the red box?

    Looks like it depends on whether the horizontal scroll bar is hiding the tabs or not. In the 1st pic, all the tabs are visible. Clicking on the arrows did nothing. Whereas in the 2nd pic, only the 1st tab is visible, clicking on the arrows will move you to the previous/next tab.

    Clipboard01.png

    Clipboard02.png
     
    abbasi and cliffordcooley like this.
  3. abbasi

    abbasi TS Enthusiast Topic Starter Posts: 355   +18

    So it depends on the number of sheets. OK. Thank you very much.
     
  4. cliffordcooley

    cliffordcooley TechSpot Paladin Posts: 6,254   +1,550

    Depends on the number of sheet tabs that are not visible, yes. If all the sheet tabs are visible there is no need for a scroll function. Basically the same as being able to scroll from top to bottom, but when the whole page is visible it doesn't move.
     
  5. abbasi

    abbasi TS Enthusiast Topic Starter Posts: 355   +18



Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.