How to know when a shortcut key is already assigned

[j_mcarthur]

When recording a macro in Word the dialog box that lets you assign a
shortcut key to the new macro shows you if any other command is
presently assigned to the key combination you'd like to choose. The
equivalent dialog box in Excel is different from the one in Word and
does not appear to have this useful feature. Hence you may unknowingly
override some built-in command when assigning a shortcut key to a macro
in excel. Word also has a nifty feature whereby you can produce a
listing of all the built-in commands, along with there currently
assigned shortcut keys. Excel does not seem to have this feature
either. So, is there any way of finding out whether a shortcut key
you're thinking of using for a macro is already assigned to another
excel command or function?

Joe

 

[Dave Peterson]

I think the easiest thing is to try the proposed shortcut keys and see what
happens.

Chip Pearson has a list of shortcut keys:
http://www.cpearson.com/excel/ShortCuts.htm

David McRitchie has one:
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Debra Dalgleish has one:
http://www.contextures.com/excel.htm

 

[Earl Kiosterud]

Dave,

I was going to suggest that, but wondered how it'd be taken. It reminds me
of the radio ads years ago when 7-11 started staying open 24 hours a day.
"How do you tell which 7-11 stores are the ones that are open 24 hours a
day?" "Easy -- they're the ones with the lights on at 2 O'Clock in the
morning."

Earl Kiosterud
www.smokeylake.com

 

[Dave Peterson]

Or Steven Wright walking toward a store that said "open 24 hours" and noticing
that the shopkeeper was closing.

I thought you were open 24 hours.
Not in a row!

http://www.fortogden.com/fosw.html