[SOLVED] How do I display all assigned keyboard shortcuts?

[Musawwir Spiegel]

Using Excel 2002, is there a way to display all keyboard shortcuts
presently assigned, both those assigned by default and those that have
been user assigned?


Musawwir Spiegel
mms@spiegel-law.com

[Bernard Liengme]

There are no user assigned shortcuts in Excel
The default ones can be found in Help - keyword SHORTCUTS
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Musawwir Spiegel" <mms@spiegel-law.com> wrote in message
news:1lat51t9a0o86fa6mln39vsp8eic7709r0@4ax.com...
> Using Excel 2002, is there a way to display all keyboard shortcuts
> presently assigned, both those assigned by default and those that have
> been user assigned?
>
>
> Musawwir Spiegel
> mms@spiegel-law.com

[JE McGimpsey]

Well, perhaps that's true for *Windows* XL. Mac XL has had user assigned
keyboard shortcuts for the last two versions...

And of course, even in Win XL you can use the Application.OnKey command
to assign keyboard shortcuts to macros.


In article <unHtFPSQFHA.2932@TK2MSFTNGP09.phx.gbl>,
"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote:

> There are no user assigned shortcuts in Excel

[Lady Layla]

But is Excel 2002 MAC or WINDOWS?


"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-47C643.14473214042005@msnews.microsoft.com...
: Well, perhaps that's true for *Windows* XL. Mac XL has had user assigned
: keyboard shortcuts for the last two versions...
:
: And of course, even in Win XL you can use the Application.OnKey command
: to assign keyboard shortcuts to macros.
:
:
: In article <unHtFPSQFHA.2932@TK2MSFTNGP09.phx.gbl>,
: "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote:
:
: > There are no user assigned shortcuts in Excel

[JE McGimpsey]

????? Bernard's comment was global...


In article <ewB#uKeQFHA.1172@TK2MSFTNGP12.phx.gbl>,
"Lady Layla" <nospam@nowhere.now> wrote:

> But is Excel 2002 MAC or WINDOWS?
>

[Lady Layla]

OP said in Excel 2002 he could do this, Bernard responded to that question.
His response may have been global or taken as global. My question was Excel2002
a MAC version or a Windows version --- if it is MAC, then there is a built in
function to do it within Excel. If it is Windoze then there is not a built in
function to do it, but there are ways to get around that.





"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-87D43F.11591615042005@msnews.microsoft.com...
: ????? Bernard's comment was global...
:
:
: In article <ewB#uKeQFHA.1172@TK2MSFTNGP12.phx.gbl>,
: "Lady Layla" <nospam@nowhere.now> wrote:
:
: > But is Excel 2002 MAC or WINDOWS?
: >

[JE McGimpsey]

Windows versions: XL97, XL2000, XL2002, XL2003

Mac versions: XL98, XL2001, XLv.X, XL2004


In article <uQWWAXeQFHA.2876@TK2MSFTNGP09.phx.gbl>,
"Lady Layla" <nospam@nowhere.now> wrote:

> OP said in Excel 2002 he could do this, Bernard responded to that question.
> His response may have been global or taken as global. My question was
> Excel2002
> a MAC version or a Windows version --- if it is MAC, then there is a built in
> function to do it within Excel. If it is Windoze then there is not a built
> in
> function to do it, but there are ways to get around that.

[Lady Layla]

Thanks!

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-E13C93.12121315042005@msnews.microsoft.com...
: Windows versions: XL97, XL2000, XL2002, XL2003
:
: Mac versions: XL98, XL2001, XLv.X, XL2004
:
:
: In article <uQWWAXeQFHA.2876@TK2MSFTNGP09.phx.gbl>,
: "Lady Layla" <nospam@nowhere.now> wrote:
:
: > OP said in Excel 2002 he could do this, Bernard responded to that question.
: > His response may have been global or taken as global. My question was
: > Excel2002
: > a MAC version or a Windows version --- if it is MAC, then there is a built
in
: > function to do it within Excel. If it is Windoze then there is not a built
: > in
: > function to do it, but there are ways to get around that.

[tonywig]

"There are no user assigned shortcuts in Excel"

??

What about keyboard shortcuts applied to recorded macros. I know I can do this in (Windows) Excel 97, not sure about other versions.

Sadly I don't know how to display them all tho - it would be useful.

[David McRitchie]

Hi Musawwir,
The was a suggestion to use shortcuts in Help --- actually
Microsoft prefers you to look under keyboard (keyboard shortcuts).
But then you look a groups, and pick a group -- not so nice.

I have a page with all of them listed so you can use the Find (Ctrl+F)
to find something and they are logically arranged (same as in Help)
so if you find what you are looking for there are similar keyboard
shortcuts near what you found.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
There are some other arrangements like based on the key
combination themselves, but you won't see much in the
definition.
---
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

"Musawwir Spiegel" <mms@spiegel-law.com> wrote in message news:1lat51t9a0o86fa6mln39vsp8eic7709r0@4ax.com...
> Using Excel 2002, is there a way to display all keyboard shortcuts
> presently assigned, both those assigned by default and those that have
> been user assigned?
>
>
> Musawwir Spiegel
> mms@spiegel-law.com