How to Use Micro in Excel
Microsoft Excel allows users to create commands that can be repeated in any spreadsheet. These commands are called "macros," though people frequently make the mistake of calling them "micros." Users generally create macros for commands that will need to be duplicated several times across a variety of spreadsheets. A user may create a macro to type out a long list of names, rather than attempting to copy and paste the list of names in each separate spreadsheet.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Excel.
-
2
Click "Tools," "Macros," then "Security." The "Security" dialog box will appear.
-
-
3
Select "Medium" from the security setting, then click "OK."
-
4
Click "Tools," "Macro," then "Record New Macro."
-
5
Type in your Macro's name in the provided box. You can only use letters and numbers in the name, no spaces or punctuation marks (except for underscores).
-
6
Type in a shortcut key that you want to use to start this macro. Again, you can use any letter or number.
-
7
Save your macro in the "Personal Macro Workbook." Saving it here allows you to access it whenever you create a new spreadsheet.
-
8
Press the blue button to begin recording your macro. Anything you do right now will be recorded into the macro. For example, if you type three names down in various boxes, when you use your macro those names will appear on your spread sheet.
-
9
Click the blue button again to stop recording your macro.
-
10
Press "CTRL" and the key you assigned to the macro in step six to use your macro.
-
1
Tips & Warnings
Any mistakes you make while recording your macro will be repeated each time you use it.
