This tutorial demonstrates how to insert a blank row after every other row in Excel and Google Sheets.
Insert a Blank Every Other Row
To insert a blank every other row (or every 3rd, 4th, or nth row), follow these steps:
- 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).
- After you filled the helper column with numbers select all of them, right-click the selection, and choose Copy (or use CTRL + C shortcut).
- 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.
- Now, select the data from the helper column and in the Ribbon go to Home > Sort & Filter > Sort Smallest to Largest.
- In the Sort Warning, window press Sort.
As a result, the space between rows will appear.
- To delete the helper column select the data, right-click it and choose Delete.
As a result, you will have data set with alternate rows.
Note: you can use VBA code to insert rows.
Insert Blank Every Other Row in Google Sheets
- 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).
- After that select all the numbers, right-click them, and choose Copy (or use the CTRL + C shortcut).
- Then select the first empty cell in the helper column (F10), right-click it (2), and choose Paste (or use the CTRL + V shortcut).
- Select all the data in the helper column (F1:F18).
- In the Menu, go to Data and click Sort sheet by column F, A → Z.
As a result, the blank rows will appear between the existing ones. Now, you just need to delete the helper column.
- To delete the helper column, select the data from the column, right-click it, and choose the Delete column.
Now, you have the data with alternate rows.