See all How-To Articles

How to Insert Blank Every Other Row in Excel & Google Sheets

This tutorial demonstrates how to insert a blank row after every other row in Excel and Google Sheets.

 

insert-blank row every other new 9

 

Insert a Blank Every Other Row

To insert a blank every other row (or every 3rd, 4th, or nth row), follow these steps:

  1. First, create a helper column. Enter 1 and 2 in the first two cells (G2 and G3), then drag down the fill handle to the last cell (G10).

 

insert-blank row every other new 1

 

  1. After you filled the helper column with numbers select all of them, right-click the selection, and choose Copy (or use CTRL + C shortcut).

 

insert blank row every other new 2

 

  1. To paste the range, select the first empty cell in the helper column (G11), right-click it, and choose Paste (or use the CTRL + V shortcut).

Note: If you want to insert two or more blank rows between existing rows just copy and paste the helper column list two or more times below the last cell.

 

insert blank row every other new 3

 

  1. Now, select the data from the helper column and in the Ribbon go to Home > Sort & Filter > Sort Smallest to Largest.

 

insert blank row every other new 4

 

  1. In the Sort Warning, window press Sort.

 

insert blank row every other new 5

 

As a result, the space between rows will appear.

 

insert blank row every other new 6

 

  1. To delete the helper column select the data, right-click it and choose Delete.

 

insert blank row every other new 7

 

As a result, you will have data set with alternate rows.

 

insert blank row every other new 8

 

Note: you can use VBA code to insert rows.

Insert Blank Every Other Row in Google Sheets

  1. To insert blank every other row in Google Sheets, create a helper column. In the helper column enter 1 and 2 in the starting cells (F1 and F2). Drag down the fill handle to the last cell (F9).

 

insert blank row every other new 10

 

  1. After that select all the numbers, right-click them, and choose Copy (or use the CTRL + C shortcut).

 

insert blank row every other new 11

 

  1. Then select the first empty cell in the helper column (F10), right-click it (2), and choose Paste (or use the CTRL + V shortcut).

 

insert blank row every other new 12

 

  1. Select all the data in the helper column (F1:F18).

 

 insert blank row every other new 13

 

  1. In the Menu, go to Data and click Sort sheet by column F, A → Z.

 

insert blank row every other new 14

 

As a result, the blank rows will appear between the existing ones. Now, you just need to delete the helper column.

 

insert blank row every other new 15

 

  1. To delete the helper column, select the data from the column, right-click it, and choose the Delete column.

 

 insert blank row every other new 16

 

Now, you have the data with alternate rows.

 

insert blank row every other new 17