Sheet tab scroll buttons don't work on Excel 2010

abbasi

Posts: 328   +24
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?
 
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
 
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.
 
Back