How can we insert fast a blank row in a list after each row?

Here’s a technique to double-space your data which is faster than any macro could do it (unless the macro utilizes this technique also!) Imagine being able to double-space thousands of rows in a split second. The secret? Sort them!

  1. Number the rows. ln this example the data is in A1:D9. We used column E for the row numbering:

  1. Copy and paste these numbers so there are 2 sets.

  1. Sort the data by this column. This sorts the blank rows into their correct place.

  1. Clear the column, and you’re done! You can use this technique to triplespace by pasting another set of row numbers before the sort!