Excel Guides

Easily Adding Blank Rows in Excel

Adding blank rows in Excel can be easily accomplished in a few different ways. One way is to insert blank rows manually by right-clicking on the row above where you want the blank row and selecting "Insert." Another way is to use the "Insert" function on the Home tab of the ribbon. Simply select the row where you want the blank row, click "Insert," and then choose "Insert Sheet Rows" from the drop-down menu.

You can also add blank rows using a macro. To do this, first open the Visual Basic Editor by pressing Alt+F11. Then, insert a new module by clicking on Insert > Module. Paste the following code into the module:

Sub InsertBlankRows()
' inserts blank rows between each existing row of data
' original data must be sorted ascending by column A
Dim i As Long, lr As Long
Application.ScreenUpdating = False
lr = Range("A" & Rows.Count).End(xlUp).Row
For i = lr To 2 Step -1
If Range("A" & i) <> Range("A" & i - 1) Then Rows(i + 1).Insert shift:=xlDown
Next i
Application.ScreenUpdating = True
End Sub

To use this macro, simply select the range of cells that contains your data (including headers), click on Run Macro > InsertBlankRows, and then press F5 to run the macro.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.