How to Create a Macro in Excel 2010

Techwalla may earn compensation through affiliate links in this story.
Create a macro in Excel 2010 to simplify complicated tasks.

Advanced users of Microsoft Excel 2010 often use macros to speed their ability to perform computing tasks. A macro is a series of instructions given to the spreadsheet software. Simple macros record your keystrokes or mouse clicks, allowing you to replicate them quickly and easily. Creating a macro in Excel 2010 automates repetitive tasks, such as complex cell formatting. You can create and save a series of macros to perform basic activities and improve your work efficiency.


Step 1

Identify a complex series of commands you frequently give Microsoft Excel. For example, you could create a macro for formatting a group of cells with 8-point, blue Times New Roman font.

Video of the Day

Step 2

Choose the "File" tab. Click "Options" and "Customize Ribbon." Select the "Developer" check box in the "Main Tabs" list to easily access the macro creation tool.


Step 3

Click "Macro Security" on the "Developer" tab. Enable macros under the "Macro Settings" area.

Step 4

Click "Record Macro" to open a window and create a new macro in Excel.


Step 5

Enter a unique name for your macro. Choose a name that begins with a letter, contains no spaces and accurately describes the macro's function.

Step 6

Select an area to store the macro by changing the "Store Macro In" field. Create a brief description of the macro so that you can remember its purpose later. Click OK to close the window and begin recording.



Step 7

Perform the series of functions you want to record. Perform each mouse click, keystroke or other function in the proper order to ensure that the macro will work properly.

Step 8

Click "Stop Recording" when you have finished your series of commands. Microsoft Excel automatically saves the macro when you click this button.


Step 9

Test the macro by selecting an area upon which you want the macro to operate. Select the macro and press "Run." Ensure that the macro performs its function correctly.


More advanced users may create a macro in Excel 2010 using Visual Basic for Applications, a type of programming language. Writing macro code in VBA allows you to perform more complex functions than basic macro recording.


Disable all macros when you have finished using them. This prevents dangerous code from running on your computer without your consent.



Report an Issue

Screenshot loading...