Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a shortcut to view a list of all worksheets and navigate | Excel Discussion (Misc queries) | |||
Navigate between worksheets | Excel Worksheet Functions | |||
Is there a keystoke to navigate between worksheets? | Excel Worksheet Functions | |||
Is there a keystoke to navigate between worksheets in a workbook? | Excel Discussion (Misc queries) | |||
How do I navigate on a click between linked worksheets in Excel? | Excel Worksheet Functions |