Microsoft Office Tutorials and References
In Depth Information
Automate your worksheet with
A macro enables you to automate a common task,
such as entering a series of dates or formatting a
column of numbers. You create a macro by recording
each step of the task and then assigning all of the
steps to a keyboard shortcut. Pressing the assigned
keyboard shortcut replays the steps.
You can use the Store macro in field of the Record
Macro dialog box to define the scope of your macro.
If you choose Personal Macro Workbook, Excel stores
your macro in a workbook named Personal.xlsb and
makes your macro available to you whenever you
To run a macro, you can use the shortcut you
assigned to the macro before you recorded it, or you
can choose a button, place it on the Quick Access
toolbar, and then click the button to run the macro.
To find out how to place a button you can use to run
a macro on the Quick Access toolbar, see Task #100.
When you save a workbook that contains a macro you
must save it as an Excel Macro-Enabled Workbook.
Click to select a cell.
Click the Record Macro button.
l The Record Macro dialog box
Type a name for the macro.
Type a letter to assign a
You can press and hold Shift and
a letter to assign a capitalized
Click here and select the scope.
Select This Workbook to make
your macro available to the
active workbook only.
Select New Workbook to place
the macro in a new workbook.
Select Personal Macro Workbook
to make the macro available to
Type a description.