Do You Know How To Set/run Macro?

Navigate to the Developer tab and select the Record Macro button in the Code group OR click the button in the bottom left corner of your screen that looks like a spreadsheet with a red dot in the top left corner.

Create a name for your macro. Spaces are not allowed, but you can use an underscore instead. In the graphic on this page, we've named our macro "Format_Report."

Select a shortcut key. Be sure to choose a letter not already being used as a shortcut key as it will replace the original (i.e., don't use Ctrl+Z unless you want to lose your shortcut for Undo). By using Shift, you can expand your options (i.e., you could use Ctrl+Shift+Z instead). In our illustration, we've designated Ctrl+Shift+R as our shortcut key.

Choose where to store your macro. Usually, you'll want to store your macro in This Workbook, which is what we've selected in our example. If you want it to be available whenever you use Excel, select Personal Macro Workbook from the drop down menu.

Type a brief description about what your macro will do in the Description box.

Click OK.

The macro recording has begun, and now it's time to perform the actions you want to record. I recommend starting with a few simple actions such as adjusting the font style or changing the color of the cell so you can get the feel for how it works.

When you're done, press Stop Recording button in the Code group on the Developer tab OR click the blue square in the lower left corner of the Excel window.Congratulations! You've just learned how to create an Excel macro!