30 points for help. excel auto insertion!! Urgent 30

Auxiliary columns such as column p.

Enter 1 on line P1 P2 P3

Select the P3 P4 row cell fill. This results in an interval of data.

Select column P, press CTRL+G, target condition, select null value, OK.

Right-click above the blank cell in column p, insert row, whole row.

Delete column p. Place the cell in cell A1.

Ctrl+A to select the worksheet.

Ctrl+G Positioning, Null, OK.

Direct input. a3

Press Ctrl+Enter to finish.

If you have any questions about the operation steps, please Q463927719

You can make a macro, open the excel file, and press alt+f11

Select the worksheet on the left, and then in the **window on the right (if you can't see the **window, press F7), enter the following content, and then save, run it, such as press F5 directly in the **window, if in the Excel file window, you can press Alt+F8 to select Run, you can also make a form button, right-click this button to specify the macro. It's more convenient.

Or just create a macro, delete the macro**, and copy the following ** into it to save it).

sub mhr()

range("4:4,6:6,8:8,10:10,12:12").select

range("a12").activate

shift:=xldown

range("d4:n4") = range("d3:n3")

range("d7:n7") = range("d6:n6")

range("d10:n10") = range("d9:n9")

range("d13:n13") = range("d12:n12")

range("d16:n16") = range("d15:n15")

cells(1, 1).select

end sub

Have you tried this method?

Just copy a line and delete it, if it's just an operation.

Select the target row you want to insert and right-click Insert.

Then you use the first row as a total, which is the easiest.

Can I send a screenshot of the ** screen?

Select 3 11, turn into a black cross when you move the mouse over the 11 cell, then hold down the shift key while holding down the left mouse button and drag a row down.

You can do 30 rows of ** first, then empty 5 rows, and then select the 30 rows and empty 5 rows of cell ranges, and use the fill handle to drag down.

Suppose your first column of data is column A, start from A6 to A100 and end with 1 in B6, enter 2 in B7, and then drop down to fill to the end of the data and then enter A101, enter A102, also drop down and fill, the number of fills is the same as the above, and then sort, you can get the schematic.

If the original data is in column A.

b1 Enter the formula.

Drop down and copy column b.

Paste Special - Numeric to column C.

Column C is the answer.

Delete columns A and B.

First pick one after the other, insert the rows, look at the ones next to each other, choose one after the other, insert the rows, and you're done twice. I can't help it any other way.

Made a tutorial for you to see.

Use if wrapping in cells"alt+enter"key to automatically add a blank line for entering new information.

Try with this macro, after entering the data on line 9, press enter, insert a blank line, the original line 9 will become line 10, and the active cell is still on line 9, continue to enter.

This macro is in the Worksheet SelectionChange and monitors changes in the active cells. The input on line 9 will not be executed until line 10.

private sub worksheet_selectionchange(byval target as range)

dim k, m as integer

k =m =

if k = 10 then 'Let's say the blank line is before line 10.

if len(cells(k - 1, m)) 0 thenrows(k - 1).insert shift:=xldowncells(k - 1, m).

activateend if

end if

end sub

After setting ** in Excel, the method of inserting a blank row after each row:

For example, the salary list in the following figure is made into a salary slip, and in order to facilitate tearing, not tearing, and affecting other people's salary slips, the method of one line is adopted;

Insert the serial number 1 in f2 and padd down to the last person;

Copy the serial number and paste it below (if you need two blank lines, paste it twice);

Take the sequence number column just now as the main keyword, sort - ascending, a reminder box will automatically pop up at this time, select "Expand Selected Area";

After clicking "Sort", the effect of one line will appear, and then delete the data in column F.

excel interlaced insert blank lines, are you still manually inserting blank lines line by line?

Use macros.

sub gehangcharuhang()' gehangcharuhang macro'Insert a row every other line.

dim i as integer

for i = 2 to 200 step 2'Adjust the maximum value as needed, here, I have 100 rows, so 100*2=200, if there are n rows, it is 2*n

rows(i & ":" & i).selectshift:=xldown, copyorigin:=xlformatfromleftorabove

next i

end sub

Add auxiliary columns, enter 1 and 3 in the first two rows with data, and then drag to become 1, 3, 5, 7....to the bottom of your data, then drag out the even-numbered arrangement of 2, 4, 6, and 8 with 2,4,6,8, and then sort and delete the auxiliary columns.

1. Enter the serial number ...... in a blank column on the right side of the data areaAll the way to the very last row of data.

2. Copy the new column number and paste it in the next line of the column number.

3. Select all data columns (including the column where you just entered the sequence number) and sort them by the main keyword of the column where the sequence number is located.

4. Clear the sequence number in the column where the newly created sequence number is located.

It's easier to use auxiliary columns.

Suppose there are 10 rows of data in it, enter 1 in the first row of the auxiliary column, and then pull down so that rows 1 to 10 are 1, 1, 2, 2, 3, 3, 4, 4, 5, 5 respectively, and then copy rows 1-10 of the auxiliary column and paste them into row 11 of the auxiliary column.

Sort the secondary columns and delete them.

1. Insert a column in column A and make a serial number to list it.

2. Copy the serial number and paste it below the last line of the serial number. Sort in ascending order.

3. Delete column A.

A hint: the incrementing sequence combines sorting.

Insert a column, enter 1 from the third row of the serial number, then select 1 and the blank cells below, enter the drop-down until the end of the row, and then go back to the positioning condition of "positioning" to select constants, and then insert the "row", and then delete the column just inserted.

How do you insert a blank line in each of these lines?

Materials required: computer, excel.

First, double-click the left mouse button to open the worksheet you want to unprotect.

Second, as you can see here, the protected worksheet is not only uninsertable, but also has a format that cannot be changed.

3. To remove the protection, click "Review" in the top navigation bar.

4. Click "Revoke Worksheet Protection" in "Change" on the review interface.

5. Once the protection is revoked, both the format and the insertion can be changed.

In this case, a portion of the blank lines should be removed, because there are too many rows instead of empty lines.

Solution: Select a part of the blank rows to be deleted, then select ""-Positioning"-"Positioning", then select "Null Value" and click OK, then right-click "Delete", select "Whole Row", and then click OK, save and re-enter Excel** to solve.

Hello, there are three situations in which this netizen will appear in your situation. Sort them out for you in turn, the first one is sheet protection. If this is the case, you will not be able to insert the entire line.

The second case is that the last row or column has a cell that is not empty, which means that your last row has content. Not even a single space.

It's just that there's a super ** overlap. This is rarely the case.

In the phase chart, this is a super table overlap, and if you insert a column in column C or D, you cannot insert it.

Love you! Boom!

Remove payroll protection and you're good to go. If you can't say anything, I'll help you!

Excel sheet protection to remove give it a try.

You see if the data table is set up to be protected.

Thanks, also helped me solve this problem.

Ways to batch insert whole rows in excel:

1.Open**, for example, if you want to insert 10 lines, then select 10 lines in the place where you want to insert rows.

2.Note that the line number is selected, and then right-click and select Insert.

3.When you're done, you'll see that 10 blank rows have been inserted at the beginning of the selection.

After inserting a row, press the F4 key continuously to repeat the last operation.

When any row is selected.

Hold down Ctrl and then press "+" to insert.

Holding down Ctrl and then pressing "-" is to delete.

Step 1: Right-click on the sequence number on the left side of any of your rows, the whole line will be highlighted in dark colorStep 2: There is a "Insert" option in the frame that appears at the key header, click on it Result:

A new line appears above the line you selected, [shortcut key] press ctrl and "+" at the same time to insert a line, ctrl and "-" to delete a line, but this method requires two hands at the same time, that is to say, to let go of the mouse, I personally think the practicality is average.

If you want to insert as many lines as you want, you can first select how many consecutive lines you want, and then right-click to insert the rows and insert how many consecutive lines you want.