My daughter phoned one day to ask how she could add an empty row between each row of data in Excel. This is a quick and easy solution:
- Insert a column to the left of Column A
- In the empty column enter “1” in the row with the 1st row of data
- AutoFill the number down
- At the bottom of the screen by the Column A, click on the AutoFill options box and select Fill Series
- The series is selected from 1 to whatever the last row would be numbered. Copy that selected series.
- Press Ctrl + down arrow to go to the bottom of the data and then go down 1 cell to the 1st empty cell below the series and Paste.
- You now have numbered the data from 1 to x and 1 to x.
- Sort the data by column A and then by column B
Tada! Every other row is blank.
HINT: Do not delete column A yet. Perhaps you would use the Group feature to hide it. When you want to resort so you do not have every other row empty, column A will be the “bridge” you need to sort all the data. Simply sort by any column other than column A.