software

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

Try:CNTRL-PAGEUP
or
CNTRL-PAGEDOWN
--
Gary's Studentquot;Brian Brandtquot; wrote:

gt; Hi...
gt; Is there a shortcut in excel., where you can shift between the different
gt; tabs you got in your document... ?
gt; Like Alt tab between windows...
gt;
gt; Kind Regards
gt; BB

there it was... thx mate...

hmm... how do you reconfigure that... if i want it to be like quot;ctrl dquot;
`... ?quot;Gary''s Studentquot; skrev:

gt; Try:
gt;
gt;
gt; CNTRL-PAGEUP
gt; or
gt; CNTRL-PAGEDOWN
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Brian Brandtquot; wrote:
gt;
gt; gt; Hi...
gt; gt; Is there a shortcut in excel., where you can shift between the different
gt; gt; tabs you got in your document... ?
gt; gt; Like Alt tab between windows...
gt; gt;
gt; gt; Kind Regards
gt; gt; BB

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 Studentquot;Brian Brandtquot; wrote:

gt; there it was... thx mate...
gt;
gt; hmm... how do you reconfigure that... if i want it to be like quot;ctrl dquot;
gt; `... ?
gt;
gt;
gt; quot;Gary''s Studentquot; skrev:
gt;
gt; gt; Try:
gt; gt;
gt; gt;
gt; gt; CNTRL-PAGEUP
gt; gt; or
gt; gt; CNTRL-PAGEDOWN
gt; gt; --
gt; gt; Gary's Student
gt; gt;
gt; gt;
gt; gt; quot;Brian Brandtquot; wrote:
gt; gt;
gt; gt; gt; Hi...
gt; gt; gt; Is there a shortcut in excel., where you can shift between the different
gt; gt; gt; tabs you got in your document... ?
gt; gt; gt; Like Alt tab between windows...
gt; gt; gt;
gt; gt; gt; Kind Regards
gt; gt; gt; BB

Hi Brian,
You would lose an important shortcut with that one: Ctrl D is Copy Down
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
www.mvps.org/dmcritchie/excel...c.htm#navigate
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Gary''s Studentquot; gt; wrote in message
...
gt; You may be able to re-configure using OnKeys. You might want to open a new
gt; posting the in Excel Programming Forum to explore further.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Brian Brandtquot; wrote:
gt;
gt; gt; there it was... thx mate...
gt; gt;
gt; gt; hmm... how do you reconfigure that... if i want it to be like quot;ctrl dquot;
gt; gt; `... ?
gt; gt;
gt; gt;
gt; gt; quot;Gary''s Studentquot; skrev:
gt; gt;
gt; gt; gt; Try:
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; CNTRL-PAGEUP
gt; gt; gt; or
gt; gt; gt; CNTRL-PAGEDOWN
gt; gt; gt; --
gt; gt; gt; Gary's Student
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Brian Brandtquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi...
gt; gt; gt; gt; Is there a shortcut in excel., where you can shift between the different
gt; gt; gt; gt; tabs you got in your document... ?
gt; gt; gt; gt; Like Alt tab between windows...
gt; gt; gt; gt;
gt; gt; gt; gt; Kind Regards
gt; gt; gt; gt; BB