In Excel, how do I record a new macro and how do I do it?

Let's take the example of recording a macro with the title "Centering across columns" to see the specific recording process

1. Execute the "Tools Macro Record New Macro" command to open the "Record New Macro" dialog box.

2. Enter a name under "Macro Name" (such as "Center across columns") and set the location where the macro will be saved.

Note: There are three types of macro storage locations: Current Workbook - macros are only valid for the current workbook; Personal macro workbooks – macros must not be valid for all workbooks; New Workbook - The recorded macro is saved in a new workbook and is valid for that workbook.

3. Press the "OK" button to start recording.

4. Operate the process of setting "Center Across Columns", and when you are done, press the "Stop Recording" button on the "Stop Recording" toolbar.

The macro recording is complete. Animation references.

Click Record Macro, enter a macro name, and save it, and all subsequent operations will be recorded until you click Stop Recording.

If you need the same operation later, you can use this macro directly.

Click the button circled in red in the lower left corner of the picture below to start recording macros, and click the button again to finish recording

Macros are often used in Excel, but how do you record macros? Here is the method of recording a new macro in excel shared by me for you to read and learn.

Excel Ways to Record New Macros:

Record macro Step 1: Go to Excel and click "Tools" -- Macros -- Record New Macro....”。

Step 2: Click the arrow to fill in the name of the macro in turn, use the shortcut key of the macro, and select the macro to save in **. If saved in the current workbook, it can only be used in the current workbook; If you save in a personal macro workbook, other workbooks can also be used.

Click the "OK" button when you're done.

Step 3: You can record the settings you need. Right-click on the cell and select Format Cell....”。

Here's how

1. Open Excel and click [File] in the upper left corner.

2. Find and click the [Options] button.

3. After the pop-up window, click [Trust Center] on the left side.

4. Then click [Trust Center Settings] in the lower right corner.

5. In the pop-up window, click [Macro Settings] on the left.

6. Select [Enable All Macros] and check [Trust Access to VBA Project Object Model].

7. After the selection is completed, click [OK].

8. Then click [View] on the upper toolbar.

9. Find the macro and click to select [Record Macro].

10. Enter the name of the macro and the location of the saved road, and then click [OK] to start recording.

11. After the recording is finished, click [Stop Recording] in the macro above.

12. When you need to use it, click [View Macro] in the macro.

13. Select the macro and click [Execute].

Tips. 1. Press alt+down arrow to automatically generate a drop-down list based on the content you have entered;

2. Press alt+= to quickly insert the summation formula;

3. Press Alt+Enter to force a line break at the specified position;

4. Select the entire area and press Alt+; When selecting, you can skip the hidden area and select only the displayed area;

5. Press the alt+number key to enter special symbols: for example, alt+41420 can be entered, alt+41409 can be entered;

6. Press Ctrl+D to fill down. Select a cell with a formula or value and the n cells below to fill the value or formula.

1. First of all, we open the excel <> on our computer

2. Then we click on Development Tools.

3. After that, we can see the macro, we click to record the macro;

4. The pop-up interface, we click OK;

4. Then we can record the macro, and when the recording is finished, we can click to stop recording. You can open a file in Excel that does not have macros enabled but contains macros enabled.

Excel2010 has the function of recording macros, the specific operation is as follows:

1. Use tools: excel2010

2. Steps:

Excel2010 has the function of recording macros, the specific operation is as follows:

1. Use tools: excel2010

2. Steps:

Recorded macros in Excel2010 are very useful tools for automatically generating VBAs that reproduce what we do in our applications. Here is the method I have compiled for Excel2010 to record macros for your reference.

First open Excel 2010 new worksheet.

On the main Developer Tools, in the ** group, click Record Macro.

The "Record Macro" window pops up, we can set the "Macro Name" and so on, or we can directly use the default settings and click "OK".

For example, let's type "hao are you?" in cell C1When you stop typing, the button is grayed out), press Enter.

Click "Stop Recording".

Then click on the "Macros" button.

In the pop-up Macro window, select Macro 1 and click Macro.

1.Here, Excel is used as an explanation tool, for example, first open the office tool and create a new document.

2.After knowing what you want to achieve, you can record the macro by opening the view menu and finding the macro button under the view menu.

3.Click the macro button as shown in the figure below to open the drop-down menu.

4.Click the "Record Macro" button in the drop-down menu as shown in the image below.

5.You can give the macro a name that is easy to remember, assuming it is named "test" as shown in the image below.

6.When all the steps are complete, click "Finish Recording" in the menu where you just clicked on the macro recording.

7.Next, you can press and hold "Alt + F8", the following window will pop up, after clicking to execute, Excel will brake to repeat the steps just operated, which realizes the function of recording macros.

View - Macro - View macro——, open the window and look at the ** inside, look at the last sentence (above the end sub), if you are right, it should be range("a1").select, delete this sentence, then save, close the window, and that's it. You try it, I wish you success!

Landlord, you only need to write a macro to take the mouse coordinates, and of course the macro you record like this is just to execute the a1 cell.