Inserting a Blank Row Between Entries in Excel

Examine the list below.

We want to insert a row between each entry. This is a small list but the technique is scalable.

To do it takes four quick steps

1. Add a sequence column with sequential numbers – see note below about how to quickly add sequential numbers.

   

2. Copy the list of sequential numbers and paste it directly below the existing numbers

   

3. Sort the list by the sequence column – lowest to highest

   

4. Job done – delete the sequence column

   

Sequential Numbers

It is easy to add sequential numbers. In the example above enter 1 in cell C2 and 2 in cell C3. Select the range C2:C3 and double click the Fill Handle (black cross bottom right corner of selected range – see image below).

This creates a sequential list of numbers all the way down to the bottom of the table.