Keyboard mappings

[John James]

When assigning a shortcut key to a macro, I cannot see which keyboard
combinations are already used by either inbuilt excel shortcuts or by
other macros.

Is there a way of seeing all keyboard combination mappings as a group?
And ideally to change them at the same time too?

 

[Guest]

When assigning a shortcut key to a macro, I cannot see which keyboard
combinations are already used by either inbuilt excel shortcuts or by
other macros.

Is there a way of seeing all keyboard combination mappings as a group?
And ideally to change them at the same time too?

Try these 3 links:

http://www.cpearson.com/excel/KeyboardShortcuts.htm
(Chip Pearson)

http://www.contextures.com/excel.htm
(Debra Dalgleish)

http://www.xcelfiles.com/GetShortCutKeys.html
(Ivan Moala)


---

 

[Guest]

Chip Pearson has a good list of available shortcuts on his web site.

http://www.cpearson.com/excel/KeyboardShortcuts.htm

 

[John James]

Thanks Jonathan and Max,

They're good sources for searching for standard excel shortcuts, or fo
searching for macro shortcuts.

I was hoping some guru would have developed something which combine
these into a nice interface so I could conveniently see which shortcu
combinations were available, the meaning of shortcuts in use, and mayb
even give the option to delete, add or change these

 

[Max]

Thanks Jonathan and Max,
They're good sources for searching for standard excel shortcuts, or for
searching for macro shortcuts.

You're welcome!

I was hoping some guru would have developed something which combined
these into a nice interface so I could conveniently see which shortcut
combinations were available, the meaning of shortcuts in use, and maybe
even give the option to delete, add or change these.

We were waiting for you to do it, and offer it ! <bg> (just kidding)
Hang around awhile for better insights from others ..

---

 

[John James]

Found this PDF file which has a more comprehensive list of
system-assigned shortcut keys (with new shortcut keys planned in Excel
7 highlighted).

http://www.isamrad.com/dgainer/1_02-23-2006.pdf

It'd be a good idea to build a summary table of keyboard shortcuts into
Excel help, n'est pas?

 

[Max]

Thanks for sharing the link, John !

---

 

[John James]

A pleasure, Max. It's good to be able to repay the favour.


If you're interested in what's coming in Excel 7, google "Excel 7
blog". Fascinating site!

This was the link on the blog which gave the keyboard shortcuts.

http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx