Tuesday, January 27, 2015

microsoft excel - How to get a list of keyboard shortcuts that I use for my macros?


I know I can find a list of standard keyboard shortcuts of excel in google or through Microsoft Office Help. But I have overwritten some of them (I wasn't using them) to assign for some of my macros that I use often. Now I don't remember exactly which ones I had overrode and I don't want to overwrite any existing useful ones, either.


I try to execute a combination of shortcut to see if it is already in use and what it does. But depending on your file/data, testing it sometimes would do nothing, even though that particular combination of keys are already assigned as a shortcut, so it isn't a guarantee way.


Isn't there any place in excel that I can just get the list of the active keyboard shortcuts? Excluding QAT (Quick Access Toolbar) shortcuts, of course.


Answer



There are few possibilities:



  1. Create Macro to link any standard URL all about KB shortcuts.

  2. Link a self created PDF file contains KB Shortcuts, with Macro.

  3. Copy & Paste KB Short cuts in any PDF file and create Macro to open that PDF via Excel.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...