In this case, "macro" is the essence of Excel. How can we record a macro?
Next, we will record a macro with the title "center across columns" as an example to see the specific recording process:
1. Run the "tool & rarr; macro & rarr; record new macro" command to open the "record new macro" dialog box.
2. Enter a name under "macro name" (for example, "center across columns") and set the macro storage location.
Note: There are three macro storage locations: the current workbook-macros are only valid for the current workbook; the personal macro workbook-macros are not valid for all workbooks; new workbook-the recording macro is saved in a new workbook, which is valid for this workbook.
3. Press "OK" to start recording.
4. Perform the "center across columns" operation. After completing the operation, click the "stop recording" button on the "stop recording" toolbar.
Macro recording completed.
Some macros need to operate on any cell. Before the operation starts, select the "relative reference" button on the "stop recording" toolbar.
The animation demonstration process is as follows: