|
Click the Office button, and then click Excel Options.
|
|
 |
|
In the left pane, click Popular.
Select the Show Developer tab in the Ribbon.
|
|
 |
|
Click the Developer or View tab.
|
|
 |
|
To record a macro with actions relative to the
initially selected cell, click the Use Relative References button.
|
|
 |
|
Click the Record Macro button.
|
|
 |
|
Type a name for the macro. Assign a shortcut key to run the macro.
|
|
 |
|
Click the Store macros in list arrow, and then select:
Personal Macro Workbook to use the macro whenever you use Excel.
New Workbook to use the macro in new workbooks.
This Workbook to use the macro only in this workbook.
|
|
 |
|
Type a description. Click OK.
|
|
 |
|
|
Click the Stop Recording button |
No comments:
Post a Comment