Why Can't I navigate Excell 2003 Worksheets via Navigation Bar

[cmazurski]

I can left click and choose a worksheet at the navigation bar but I cannot
use the arrows to move either between worksheets or to the first or last
worksheet

 

[Tom Hutchins]

Is this what you mean? Right-click on the navigation bar to pop up a list of
all the visible sheets in the workbook. You can use the arrow keys and Enter
to select a sheet from this pop-up menu.

Also, you can use the navigation bar as you described; you can click on the
desired sheet tab; you can use CTRL+PAGE UP to move to the sheet to the left
of the active sheet and CTRL+PAGE DOWN to move to the sheet to the right of
the active sheet; and you could use a hyperlink or macro to move to a
different sheet. There are probably more I haven't remembered.

Hope this helps,

Hutch

 

[cmazurski]

The problem is i can ONLY use it the way I mentioned in my first post, If i
click on either arrow to go to next page or previous or the arrows for first
page and last page Nothing happens, Excell does NOT go anywhere, It acts as
if the arrows weren't even there other than the fact that I CAN right click

 

[Gord Dibben]

Left-clicking on the navigation arrows will not select a sheet.

It just slides the visible sheets left or right.

i.e. You have 20 sheets with 1 to 7 visible and sheet 3 active.

Left click on right navigation arrow and 14 to 20 will be visible but sheet 3
will still be active.


Gord Dibben MS Excel MVP