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

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

TomHutchins
Thu May 08 14:46:02 CDT 2008

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" wrote:

> 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

cmazurski
Mon May 12 10:40:02 CDT 2008

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
on them and switch sheets that way.

"Tom Hutchins" wrote:

> 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" wrote:
>
> > 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

Gord
Mon May 12 20:01:45 CDT 2008

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


On Mon, 12 May 2008 08:40:02 -0700, cmazurski
<cmazurski@discussions.microsoft.com> wrote:

>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
>on them and switch sheets that way.
>
>"Tom Hutchins" wrote:
>
>> 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" wrote:
>>
>> > 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