Inserting blank rows between the rows of a database

This blog post is about inserting rows between the rows of a database. Selecting rows one by one and insert row is very exhausting especially when there are so many rows to do so. A better solution is as follow,

Consider the database shown in the image below.

A sample Database in an Excel Spreadsheet

Step 1:

Insert a column to the left of the database and type numbers from 1 to the last row number of database-1. (here we have data up to row 16, so I will type number from 1 to 15)

Inserting a column to the database


Step 2:

Now copy the group of numbers under each other, how many times? Depends on the number of blank row you want. For example, I want to insert 2 blank rows between each row. So I copy and paste these numbers twice under each other:

Inserting group of numbers

Step 3:

Now select whole database and go to Data>sort and do as shown in below figure:

Data & Sort Database

After clicking OK you will have 2 blank rows between your database rows. Then you can delete the helper column (column A)

Database Blank Rows

And after deleting the helper column (column A) we will have this:

After deleting the database helper column

Additionally, for inserting a column between columns in a database, do similar steps above and set the option in sort to left to right, then do as shown above.

Inserting column between columns in a database


Published by

bSuperior System Ltd Experts

We are experts in customizing Excel files and VBA programming. We create Excel files for specific needs. We develop VBA programs to automate tasks and execute processes automatically . We are based in Vancouver BC, Canada.

Leave a Reply

Your email address will not be published. Required fields are marked *