When you want to create a shortcut, then the Macros function helps. For example, you can create a shortcut to record keystrokes by performing its function and saving it for your use.  Here's how you can create and record a macro in MS Excel Open Excel and navigate to the View tab Click on Macros and select the Macros command  Tap on Record Macro  Give a name to the Macro, add a shortcut key and enter where it should be accessible (location) in the dialog box that appears. You should also specify the working of this Macro and then press the OK button. The Macros will now record the function you perform. Follow the steps below to stop recording Macro: Head over to the View section Go to Macros and hit the Macros command  Now, press on Stop Recording  Thus, you have successfully created and recorded a Macro. When you want to implement it, use the shortcut keys, which will run. Further, ensure that you can use the Macros only in your location. If you had specified its location as a workbook, then the Macros will only be available in that workbook.