How to Record a Macro in Microsoft Excel
See Microsoft Excel: Tips and Tricks for similar articles.Follow these five steps to record a macro in Excel:
This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.
- On the View tab, in the Macros group, click the Macros command.
- Click Record Macro.
- In the Record Macro dialog box:
- Enter a Macro name. Choose a name that clearly identifies the macro. You may not use spaces.
- Enter a Shortcut key. You will be able to run the macro using this shortcut key.
- Choose where to store the macro. You will normally accept the default (This Workbook).
- Enter a Description. Briefly explain what the macro does.
- Click OK.
- After clicking OK, every keystroke is recorded.
- To stop recording, on the View tab, in the Macros group, click the Macros command and then click Stop Recording.
Related Articles
- Use Excel 365 to create a Sorting Hat and House Point Scoreboard
- How to Use the VLOOKUP Function in Microsoft Excel
- How to Group and Ungroup Data in a List in Microsoft Excel
- How to Use the Fill Handle in Microsoft Excel
- How to Record a Macro in Microsoft Excel (this article)
- How to Use the Quick Analysis Tool in Microsoft Excel
- How to Format Numbers in Microsoft Excel
- How to Add Shapes in Microsoft Excel
- How to Quickly Name Multiple Single Cells in Microsoft Excel
- How to Insert a Slicer in a Pivot Table in Microsoft Excel
- How to Create a Pivot Table Timeline in Microsoft Excel
- How to Insert a Chart in Microsoft Excel
- How to Set Locale in Microsoft Excel
- How to Convert a List to a Table in Microsoft Excel
- How to Use the LEFT and RIGHT Functions in Microsoft Excel
- How to Add a Macro to the Quick Access Toolbar in Microsoft Excel
- How to Insert Clip Art in a Microsoft Excel Worksheet
- How to Select a Range of Cells in Microsoft Excel
- How to Use Smart Lookup in Microsoft Excel
- How to Split the Worksheet Window in Microsoft Excel
- Microsoft Excel 2016 Isn't Much Different from Excel 2013 or Excel 2010
- How to Accept and Reject Changes in Microsoft Excel
- How to Insert a Pivot Table in Microsoft Excel
- How to Use Ink Equations in Microsoft Excel
- How to Create a Formula That Spans Multiple Microsoft Excel Worksheets
- How to Use the CONCATENATE Function in Microsoft Excel
- How to Set Tracking Options in Microsoft Excel
- How to List Day Names in Excel without Dates
- How to Freeze Panes in Microsoft Excel