Stop Automatic Tab Scrolling

[janeml]

How do I disable automatic tab scrolling?

For example:

If I have a Workbook with 25 tabs. If I'm working off Tab 1, I see tabs 1-10 at the bottom of my workbook. However, if I jump to Tab 5, my view of the tabs will jump to 5-15 instead of remaining on tabs 1-10. How do I disable this feature?

Thanks in advance!

[MarvinP]

Hi,
Instead of trying to stop tabs from scrolling across the bottom of the sheet, try this.
Right click on the 4 arrow keys just to the left of tab 1. This will give you an entire list of all tabs and you can select from them.

Does that work for you?

[janeml]

Hi,
That works...thanks. But I'd still prefer to figure out how to disable the automatic scrolling.

[MarvinP]

Hi,
In Excel 2010 you can turn off the tabs from showing.

Do File -> Options -> Advanced -> Display Options for this Workbook and uncheck the
Show sheet Tabs box