How to insert the same row in each row of an existing EXCEL table?

1, open a form, enter the relevant content in the form, and then you need to add a line of the same content after each name. For example, the contents include: serial number, name, job, salary and total.

2. At this time, you can directly insert the edited content in the first line, then copy and paste it into the other two lines, and enter a number in each line.

3. Then select the contents of column A and sort them in ascending order.

4. Click OK so that you can insert the same row in each row.

5、