Excel file - adding rows

Question

I have an Excel file which has data loaded into many columns. Is it possible to add new rows, between every other current row, without any data loaded into the newly added rows, without disturbing the current data in the current rows. I can do it one at a time, but I would like to do it all at one time.

Answer 1

Worked like a charm. Thanks for the reply.

Answer 2

You can add a couple temporary helper columns that will sort the empty rows in-between the existing rows. I will call them Sort 1 and Sort 2.

In Sort 1 number all of the existing rows to be sorted 1-??, however many rows you have. Then number the same number of rows underneath that which will be the blank rows to be inserted between the data rows. I illustrated it with 10 rows of data in the screenshot below.

In Sort 2 Enter the letter A into all of the existing rows and the letter B into all of the second set of blank rows.

Then sort by Sort 1 and then Sort 2 which will sort the empty rows in between the data rows.

You can then delete the two Sort columns when done if desired.