You are viewing the article How to Use Macros in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 14,144 times.
This wikiHow teaches you how to activate, create, execute, and save macro commands in Microsoft Excel. Macros are small programs that allow users to perform complex tasks such as calculating formulas or creating charts in Excel. Macros can save you considerable time when performing repetitive tasks, and thanks to the “Record Macro” feature, you can still create macro commands even if you don’t know anything about programming.
Steps
Enable macros
![Image titled Use Macros in Excel Step 1](https://www.wikihow.com/images_en/thumb/9/90/Use-Macros-in-Excel-Step-1-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-1-Version-4.jpg)
- If you want to open a specific file in Excel, double-click it.
![Image titled Use Macros in Excel Step 2](https://www.wikihow.com/images_en/thumb/6/64/Use-Macros-in-Excel-Step-2-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-2-Version-4.jpg)
- On a Mac, click the Excel tab in the upper-left corner of the screen to open a drop-down menu.
![Image titled Use Macros in Excel Step 3](https://www.wikihow.com/images_en/thumb/7/73/Use-Macros-in-Excel-Step-3-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-3-Version-4.jpg)
- On a Mac, click Preferences… in the drop-down menu.
![Image titled Use Macros in Excel Step 4](https://www.wikihow.com/images_en/thumb/6/6f/Use-Macros-in-Excel-Step-4-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-4-Version-4.jpg)
- On a Mac, click Ribbon & Topbar in the Preferences window.
![Image titled Use Macros in Excel Step 5](https://www.wikihow.com/images_en/thumb/0/0a/Use-Macros-in-Excel-Step-5-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-5-Version-4.jpg)
![Image titled Use Macros in Excel Step 6](https://www.wikihow.com/images_en/thumb/1/17/Use-Macros-in-Excel-Step-6-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-6-Version-4.jpg)
- On a Mac, click Save here.
Macro recording
![Image titled Use Macros in Excel Step 7](https://www.wikihow.com/images_en/thumb/6/67/Use-Macros-in-Excel-Step-7-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-7-Version-4.jpg)
- You can also close Excel and double-click the file to open the specific workbook.
![Image titled Use Macros in Excel Step 8](https://www.wikihow.com/images_en/thumb/3/3c/Use-Macros-in-Excel-Step-8-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-8-Version-4.jpg)
![Image titled Use Macros in Excel Step 9](https://www.wikihow.com/images_en/thumb/2/28/Use-Macros-in-Excel-Step-9-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-9-Version-4.jpg)
![Image titled Use Macros in Excel Step 10](https://www.wikihow.com/images_en/thumb/a/ab/Use-Macros-in-Excel-Step-10-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-10-Version-4.jpg)
![Image titled Use Macros in Excel Step 11](https://www.wikihow.com/images_en/thumb/8/8f/Use-Macros-in-Excel-Step-11-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-11-Version-4.jpg)
- On a Mac, the keyboard shortcut will include the ⌥ Option + ⌘ Command key and the character (for example, ⌥ Option + ⌘ Command + T ).
![Image titled Use Macros in Excel Step 12](https://www.wikihow.com/images_en/thumb/e/ed/Use-Macros-in-Excel-Step-12-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-12-Version-4.jpg)
![Image titled Use Macros in Excel Step 13](https://www.wikihow.com/images_en/thumb/a/ad/Use-Macros-in-Excel-Step-13-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-13-Version-4.jpg)
![Image titled Use Macros in Excel Step 14](https://www.wikihow.com/images_en/thumb/a/ab/Use-Macros-in-Excel-Step-14-Version-4.jpg/v4-728px-Use-Macros-in-Excel-Step-14-Version-4.jpg)
![Image titled Use Macros in Excel Step 15](https://www.wikihow.com/images_en/thumb/5/56/Use-Macros-in-Excel-Step-15-Version-3.jpg/v4-728px-Use-Macros-in-Excel-Step-15-Version-3.jpg)
- Click and drag the mouse over the data to select.
- Click Insert
- Select a chart shape.
- Click the chart that you want to use.
![Image titled Use Macros in Excel Step 16](https://www.wikihow.com/images_en/thumb/3/3a/Use-Macros-in-Excel-Step-16.jpg/v4-728px-Use-Macros-in-Excel-Step-16.jpg)
Save a macro-enabled workbook
![Image titled Use Macros in Excel Step 18](https://www.wikihow.com/images_en/thumb/a/a1/Use-Macros-in-Excel-Step-18.jpg/v4-728px-Use-Macros-in-Excel-Step-18.jpg)
![Image titled Use Macros in Excel Step 19](https://www.wikihow.com/images_en/thumb/1/10/Use-Macros-in-Excel-Step-19.jpg/v4-728px-Use-Macros-in-Excel-Step-19.jpg)
![Image titled Use Macros in Excel Step 20](https://www.wikihow.com/images_en/thumb/8/8e/Use-Macros-in-Excel-Step-20.jpg/v4-728px-Use-Macros-in-Excel-Step-20.jpg)
- Skip this step on a Mac computer.
![Image titled Use Macros in Excel Step 21](https://www.wikihow.com/images_en/thumb/a/a5/Use-Macros-in-Excel-Step-21.jpg/v4-728px-Use-Macros-in-Excel-Step-21.jpg)
![Image titled Use Macros in Excel Step 22](https://www.wikihow.com/images_en/thumb/c/c7/Use-Macros-in-Excel-Step-22.jpg/v4-728px-Use-Macros-in-Excel-Step-22.jpg)
- On a Mac, you need to replace the “xlsx” extension at the end of the filename with xlsm .
![Image titled Use Macros in Excel Step 23](https://www.wikihow.com/images_en/thumb/9/9f/Use-Macros-in-Excel-Step-23.jpg/v4-728px-Use-Macros-in-Excel-Step-23.jpg)
- On a Mac, you’ll need to click the “Where” drop-down box first.
![Image titled Use Macros in Excel Step 24](https://www.wikihow.com/images_en/thumb/3/34/Use-Macros-in-Excel-Step-24.jpg/v4-728px-Use-Macros-in-Excel-Step-24.jpg)
Execute macros
![Image titled Use Macros in Excel Step 25](https://www.wikihow.com/images_en/thumb/9/97/Use-Macros-in-Excel-Step-25.jpg/v4-728px-Use-Macros-in-Excel-Step-25.jpg)
![Image titled Use Macros in Excel Step 26](https://www.wikihow.com/images_en/thumb/6/66/Use-Macros-in-Excel-Step-26.jpg/v4-728px-Use-Macros-in-Excel-Step-26.jpg)
- If you don’t see the above option, skip this step.
![Image titled Use Macros in Excel Step 27](https://www.wikihow.com/images_en/thumb/6/6c/Use-Macros-in-Excel-Step-27.jpg/v4-728px-Use-Macros-in-Excel-Step-27.jpg)
- Or you can press the set key combination for the macro command. If you choose this method, you can skip the rest of the method.
![Image titled Use Macros in Excel Step 28](https://www.wikihow.com/images_en/thumb/7/78/Use-Macros-in-Excel-Step-28.jpg/v4-728px-Use-Macros-in-Excel-Step-28.jpg)
![Image titled Use Macros in Excel Step 29](https://www.wikihow.com/images_en/thumb/b/bd/Use-Macros-in-Excel-Step-29.jpg/v4-728px-Use-Macros-in-Excel-Step-29.jpg)
![Image titled Use Macros in Excel Step 30](https://www.wikihow.com/images_en/thumb/9/93/Use-Macros-in-Excel-Step-30.jpg/v4-728px-Use-Macros-in-Excel-Step-30.jpg)
Advice
- Macros are often very useful in automating tasks that you perform frequently, such as calculating payroll at the end of the week.
Warning
- Although most macro commands are harmless, a few can make dangerous changes or delete information on your computer. Never open a macro from an untrusted source.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 14,144 times.
This wikiHow teaches you how to activate, create, execute, and save macro commands in Microsoft Excel. Macros are small programs that allow users to perform complex tasks such as calculating formulas or creating charts in Excel. Macros can save you considerable time when performing repetitive tasks, and thanks to the “Record Macro” feature, you can still create macro commands even if you don’t know anything about programming.
Thank you for reading this post How to Use Macros in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: