Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Hi...
Is there a shortcut in excel., where you can shift between the different tabs you got in your document... ? Like Alt+tab between windows... Kind Regards BB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Try:
CNTRL-PAGEUP or CNTRL-PAGEDOWN -- Gary's Student "Brian Brandt" wrote: Hi... Is there a shortcut in excel., where you can shift between the different tabs you got in your document... ? Like Alt+tab between windows... Kind Regards BB |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
there it was... thx mate...
hmm... how do you reconfigure that... if i want it to be like "ctrl + d" `... ? "Gary''s Student" skrev: Try: CNTRL-PAGEUP or CNTRL-PAGEDOWN -- Gary's Student "Brian Brandt" wrote: Hi... Is there a shortcut in excel., where you can shift between the different tabs you got in your document... ? Like Alt+tab between windows... Kind Regards BB |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
You may be able to re-configure using OnKeys. You might want to open a new
posting the in Excel Programming Forum to explore further. -- Gary's Student "Brian Brandt" wrote: there it was... thx mate... hmm... how do you reconfigure that... if i want it to be like "ctrl + d" `... ? "Gary''s Student" skrev: Try: CNTRL-PAGEUP or CNTRL-PAGEDOWN -- Gary's Student "Brian Brandt" wrote: Hi... Is there a shortcut in excel., where you can shift between the different tabs you got in your document... ? Like Alt+tab between windows... Kind Regards BB |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shortcut
Hi Brian,
You would lose an important shortcut with that one: Ctrl+D is Copy Down http://www.mvps.org/dmcritchie/excel/shortx2k.htm You can create a macro, which has a little advantage over the shortcut i.e. you are working with the mouse. I use toolbar icons to invoke the macros but you could assign to shortcuts. I won't have likely created the macros and toolbar icons had I seen the Ctrl+PageUp and CtrlPageDown shortcuts. Since I have other related toolbar buttons next to these, I can use the mouse to go up or down through the tabs, and to delete sheets that have no event macros with them. For your use, if you use ctrl+d, you don't gain much except to change the shortcut from your right hand to your left hand don't know what shortcut you would use in the other direction.. navigating to the Previous and Next sheets are described in BuildTOC http://www.mvps.org/dmcritchie/excel...c.htm#navigate -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Gary''s Student" wrote in message ... You may be able to re-configure using OnKeys. You might want to open a new posting the in Excel Programming Forum to explore further. -- Gary's Student "Brian Brandt" wrote: there it was... thx mate... hmm... how do you reconfigure that... if i want it to be like "ctrl + d" `... ? "Gary''s Student" skrev: Try: CNTRL-PAGEUP or CNTRL-PAGEDOWN -- Gary's Student "Brian Brandt" wrote: Hi... Is there a shortcut in excel., where you can shift between the different tabs you got in your document... ? Like Alt+tab between windows... Kind Regards BB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut for Zooming | Excel Worksheet Functions | |||
Keyboard shortcut not working when I copy macro to another computer | New Users to Excel | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) |