How to Create Custom Keyboard Shortcuts in Excel 2007?

Excel has lot of functions and most of the functions doesn’t have any keyboard shortcuts as they are used in only very specific conditions and cases. But for some cases, you may be required to do those tasks quite often and you may like if you have a keyboard shortcut.

Let me give an example, we have covered earlier how to convert rows to columns or columns to rows in Excel and while using formulas. Its just the transpose feature in the special copy feature. But if you are required to use this task quite often, you may create your own keyboardshortcut to do the transpose paste like Ctrl + T.

So how to create custom keyboard shortcuts in Excel 2007?

Before we proceed on the section of how to do create custom keyboard shortcuts, this method is done using the macros in Excel. For some Macros may not be enabled (you may not be able to see Developer tab), please refer to our previous post on How to Enable Macro Features and Settings in Excel from Office 2007? 

To create a custom keyboard shortcut, go to the Developer tab and press Record Macro.

Give the details of the macro, the keyboard shortcut, store macro in and description.

 Side Note: If you have not saved any macros before in Personal Macro Workbook (Personal.xlsb), you may get the message like this. “Do you want to save the changes made to Personal Macro Workbook? If you click Yes, It will be available next time you start MicrosoftOffice Excel”. Click here to know more about Working with Personal Macro Workbook in Excel

Next, perform the function that you want to be repeated by a keyboard shortcut (Make sure you have done whatever function that usually precedes the function that is being recorded, like copying some cells in this case) . In our example, right click in the place where you wanted to paste special with transpose. Select Paste Special -> Transpose –>Ok. Stop recording the macro.

Now you can use the keyboard shortcut you have mentioned to perform this custom function