![]() ![]() You can also add a keyboard shortcut by recording a macro. In Excel, you can record a macro to automate specific actions and you can assign a keyboard shortcut to the macro. To create a macro and assign a keyboard shortcut: You'll be using the Record Macro dialog (below) to create keyboard shortcuts: To keep things simple, we'll use the Record Macro button on the View tab in the Ribbon. Open the file you want to use or create a new workbook.Under Macro Name, name the macro (no more than 255 characters and do not include spaces or begin with a number or an underscore).Under Shortcut key, enter a keyboard shortcut.For example, type Shift + H (this would assign Control + Shift + H as the shortcut). Under Store macro in, choose This Workbook, New Workbook or Personal Macro Workbook.īy adding Shift, you are less likely to create the same shortcut as a built-in Excel shortcut.For global shortcuts, save the macro in the Personal Macro Workbook which is launched on startup and is hidden by default. If you store a macro in another workbook, it will need to be open to run the macro. Under Description, you can enter a description.Perform the actions you want to record.Click the View tab, click on Macros and then select Stop Recording.įor example, click Paste on the Home tab, choose Paste Special and then click on Values in the dialog box. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |