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
- If you want to open a specific file in Excel, double-click it.
- On a Mac, click the Excel tab in the upper-left corner of the screen to open a drop-down menu.
- On a Mac, click Preferences… in the drop-down menu.
- On a Mac, click Ribbon & Topbar in the Preferences window.
- On a Mac, click Save here.
Macro recording
- You can also close Excel and double-click the file to open the specific workbook.
- On a Mac, the keyboard shortcut will include the ⌥ Option + ⌘ Command key and the character (for example, ⌥ Option + ⌘ Command + T ).
- Click and drag the mouse over the data to select.
- Click Insert
- Select a chart shape.
- Click the chart that you want to use.
Save a macro-enabled workbook
- Skip this step on a Mac computer.
- On a Mac, you need to replace the “xlsx” extension at the end of the filename with xlsm .
- On a Mac, you’ll need to click the “Where” drop-down box first.
Execute macros
- If you don’t see the above option, skip this step.
- 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.
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: