MACROS RECORDED IN EXCEL CAN ONLY BE APPLIED TO THE ORIGINAL CELLS

Method: After pressing "Tools-Macro-Record Macro", the subsequent operations in Excel will be recorded by Excel in the form of ** until you press "Stop Recording". For example, if you need to automatically fill in a piece of text in the "selected cell", such as "abcd", you can follow the steps below:

Select any cell first, and then press "Tools-Macro-Record Macro".

Enter "abcd".

Press "Stop Recording" to finish.

You can also assign a shortcut to this macro.

The method is to press "Tools-Macro-Macro".

In the pop-up window, select the macro you just recorded, press "Options", and you can specify a shortcut key, such as Ctrl+P.

When using this macro, you can select a cell to which you want to add text, press Ctrl+P to automatically execute the macro, and display "abcd" in the cell.

Whether you selected a cell after the recording started, if you selected a cell, then you will still appear in that cell when you execute the macro again (you can turn on the macro ** range(.)."d5").If you don't select a cell, then your recording will be in your current cell position when you execute the macro again.

Maybe you didn't click [Use Relative References] when you started recording, you need to click before recording, and then you can apply the content of this macro to other cells after you finish recording.

Because you didn't move the cell in the first place!

1. First of all, we click to open the excel on the computer, and then click on the development tools in the toolbar;

2. In the pop-up interface, we click Record Macro;

3. In the pop-up interface, we don't change the macro name, and then click OK;

4. Enter the content of the recorded macro in **;

5. After that, click to stop recording macro;

6. Then we select any cell in **, and then click the macro in the toolbar;

7. In the pop-up interface, we select the macro we just recorded, and then click Execute;

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.

Illustrate.

Step 5: Select Sheet2

Method steps.

After pressing "Tools-Macro-Record Macro", your subsequent operations in Excel will be recorded by Excel in ** until you press "Stop Recording". For example, if you need to automatically fill in a piece of text in the "Selected Cell", such as "abcd", you can follow the steps below: select any cell first, and then press "Tools-Macro-Record Macro".

Enter "abcd".

Press "Stop Recording" to finish.

You can also assign a shortcut to this macro by pressing "Tools-Macro-Macro".

In the pop-up window, select the macro you just recorded, press "Options", and you can specify a shortcut key, such as Ctrl+P.

When using this macro, you can select a cell to which you want to add text, and press CTRL+P to automatically execute the macro and display "abcd" in the cell.

excel

In 2007, select the development tools, the second menu item on the left is macro, and then the first one on the right is the recording macro, click on the recording macro and it's OK.

What version are you? I'll make a video for you to see.