How to set macros in excel to help

To put it bluntly, it's the format of making a pay slip! ** Below:

sub plus the title ().

rows(1).select

b = - 2

for a = 1 to b

rows( +2).select

shift:=xldown

next = false

end sub

Remember! Hope it works for you!

After clicking the button icon on the form, draw a button in **, select New in the pop-up macro dialog box, and enter the following:

dim a, i as integer

a = "Name").columns(1)) 1range("a1:g1").select= false

for i = 1 to a * 2 - 1if i = 1 then

i = i + 2

elsei = i + 1

end if

rows(i & ":" & i).selectshift:=xldown

next i

Note that the above ** first data area starts from cell A1.

Put the original data you want to put in sheet1, this is a table header: such as *** salary scale starts with the second line.

sub makesalarylist()

dim i as integer

dim endrow as integer

The last row of the measured data.

endrow = "a65536").end(xlup).row

Paste the title over.

worksheets(1).range("1:1").copy (worksheets(2).cells(1, 1))

for i = 3 to endrow

Paste each piece of data on your header.

worksheets(1).range("2:2").copy (worksheets(2).cells(3 * i - 7, 1))

Paste the data in the past.

worksheets(1).range(cells(i, 1), cells(i, 256)).copy (worksheets(2).cells(3 * i - 6, 1))

next i

end sub

1. Open Excel** and click to enter the development tool next to it.

2. After Tanqingzhou enters the development tool, click on the macro security in the ** option.

3. After clicking on macro security, you can trust the central macro settings, and then check Enable all macros.

4. Then check Enable all macros, and you can use macros.

1. First of all, in the computer, click on Excel to start, and create a new Excel document.

2. After opening Excel**, click "File" in the upper left corner.

3. Click "Options" on the "File" page, as shown in the figure below.

4. Then click on "Trust Center Settings" in the page that opens, as shown in the following figure.

5. Then on the page that opens, click "Macro Settings", check "Enable all macros", and then click "Save".

1. First of all, to record a new macro, simply put, it is to record the steps to be repeated. To do this, click Tools - Macros - Record a new macro. After clicking, you will start to enter the macro recording, and record the steps step by step.

2. If the steps have been recorded, click the stop button to end the recording.

3. Click Tools - Macro - Macro - Select the name of the recorded macro - Select the current workbook - Execute. If you only need one step of the macro, you can also click Step Through. If you know how to code, you can click and write ** directly.

4. Renderings.

Here's how to enable macros in Excel:

1. Open an Excel file, left-click the calendar menu [File] [Excel Options], and the [Excel Options] window will pop up;

2. On the [Excel Options] window, find the [Trust Center] tab, and click the mouse to open its settings page;

3. On the [Trust Center] window, find the [Trust Center Settings] button, click the left mouse button, and set it on the setting parameter window;

4. On the [Macro Settings] window, you can see that the parameter (Macro Settings) is (Disable All Macros and Send a Notification), which is the default option, if it is not enabled, the macros you made by yourself cannot be used;

5. On the [Macro Settings] window, change the parameters of (macro settings) and select (enable all macros), so that the macros you made can be used;

6. In the [Development Tools] column, you can record your own macro, make a macro to modify the color of the cell, record it, and reuse the macro on other cells.

Material Tools: Excel2010

1. First of all, we click to open the excel on our computer;

2. Then we click the Microsoft button in the upper left corner of the computer;

3. On the interface of playing the errand limb, we click on the excel option;

4. In the pop-up interface, we find the "Development Tools" tab in the ribbon in the general one;

5. We will check the "Development Tools" tab in the function Lushi area, and then click OK;

6. Then click on the development tools in the toolbar;

7. After that, we can see the macro inside, and we can go into the Qingzao line to record the macro, and then use the macro function.