Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move between worksheets using the keyboard
I would love to know how i can move between worksheets in a workbook without
having to click on each tab to show it. Is there a keyboard function that can do this instead of using the mouse to click on each sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move between worksheets using the keyboard
Press Ctrl+Page Up (move left), Ctrl+Page Down (move right)
If you right-click on the "vcr" arrow buttons at the bottom left corner (just to the left of the leftmost sheet tab), you'd get a pop-up listing to easily navigate to any visible sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "R Oconnor" wrote: I would love to know how i can move between worksheets in a workbook without having to click on each tab to show it. Is there a keyboard function that can do this instead of using the mouse to click on each sheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move between worksheets using the keyboard
Excellent....Thankyou
"Max" wrote: Press Ctrl+Page Up (move left), Ctrl+Page Down (move right) If you right-click on the "vcr" arrow buttons at the bottom left corner (just to the left of the leftmost sheet tab), you'd get a pop-up listing to easily navigate to any visible sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "R Oconnor" wrote: I would love to know how i can move between worksheets in a workbook without having to click on each tab to show it. Is there a keyboard function that can do this instead of using the mouse to click on each sheet? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move between worksheets using the keyboard
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "R Oconnor" wrote in message ... Excellent....Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
move between worksheets using the keyboard
Just for info.
If you open Help and type in "keyboard shortcuts" you will get quite a list of shortcuts like the CTRL + Pageup and down that Max suggested. Not that I am trying to discourage you from posting questions, but just that it may be quicker to use help sometimes. Gord Dibben MS Excel MVP On Wed, 4 Oct 2006 23:35:01 -0700, R Oconnor wrote: Excellent....Thankyou "Max" wrote: Press Ctrl+Page Up (move left), Ctrl+Page Down (move right) If you right-click on the "vcr" arrow buttons at the bottom left corner (just to the left of the leftmost sheet tab), you'd get a pop-up listing to easily navigate to any visible sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "R Oconnor" wrote: I would love to know how i can move between worksheets in a workbook without having to click on each tab to show it. Is there a keyboard function that can do this instead of using the mouse to click on each sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard arrows won't move cursor! | Excel Discussion (Misc queries) | |||
Excel 03 keyboard move to next cell? | Excel Discussion (Misc queries) | |||
How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
How do I move information between worksheets? | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions |