How to Create a Macro in Excel 2010

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.

...
Create a macro in Excel 2010 to simplify complicated tasks.

Step

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.

Step

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

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

Step

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

Step

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

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

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

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

Step

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.