Please excel macro definition how to use

Hello dear, the macro in excel should be able to use batch repetition processing that requires a certain rule or pattern. The processing method is as follows:1

Confirm that the excel program allows macros to run. In most versions of Excel, this setting is located in the "Security" section. 2.

Open the electron that contains the macro (or will be added soon). Confirm that the specific electron is macro-enabled, that is, macros are allowed to run. 3.

Choose how you want to use macros, run macros from the menu, or connect to a button in Electron to turn on electron to run macros automatically, or try using key commands. 4.If you don't have the macros you want to use installed in Electronics, you can record or write macros to organize some commands together as a single command for a specific task.

5.Open the macro menu, which is located in the Tools section of Excel. Test run the macro you want to use to make sure it's working.

Assign macros to any button, keyboard command, or electron you want to work with. Run the macro. I'm glad to answer for you, I wish you a happy life and all the best!

Summary:1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click options. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. 3. Click the Development Tools option in the menu bar, and then click Record Macro. 4. Fill in the name and shortcut key, set the save location, and click OK.

5. Change the color of excel** to red. 6. After the Excel macro is recorded, you can click to stop recording. 7. Click the mouse to other positions, and then press the shortcut key to modify the color.

Demo Environment Information:Computer model: thinkpad wing 14 slim, system version: window10 home Chinese version, software version: excel2020.

1. After turning on the computer, create a new excel, click the office icon in the upper left corner of the main interface, and click the coarse suppression option. The specific steps are shown in the following figure:

2. In the new interface, check the development tools option and click OK. The specific steps are shown in the following figure:

3. Click the Development Tools option in the menu bar, and then click Record Macro. The specific steps are shown in the following figure:

4. Fill in the name and shortcut key, set the save location, and click OK. The specific steps are shown in the following figure:

5. Change the color of excel** to red. The specific steps are shown in the following figure:

6. After the Excel macro is recorded, you can click to stop recording. The specific steps are shown in the following figure:

7. Click the mouse to other positions, and then press the shortcut key to modify the color. The specific operation steps are shown in the following figure: <>

Note: In the above operation steps, you need to operate in order, do not shuffle the order.