How to automatically insert rows in Excel?
If you need to insert blank rows frequently in a worksheet, you can right click the entire row to select Insert to insert a blank row. However, maybe the right-click method is not convenient enough for you. Now I introduce some shortcuts for you to insert blank rows in Excel.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
Fortunately, there are shortcuts that can quickly insert blank row in Excel.
Select the entire row which you want to insert a blank row above, and press Shift + Ctrl + + keys together, then a blank row is inserted.
There is a VBA code can create another shortcuts for inserting blank row.
1. Press Alt + F11 keys to open the Microsoft Visual Basic For Applications window.
2. Click Module > Insert to insert a Module window, and copy the below VBA into the window.
VBA: Insert blank row.
Public Sub InsertRow() ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Insert Shift:=xlDown End Sub
3. Close the window and return back to Excel, and press Alt + F8 keys to open Macro dialog.
4. In the Macro dialog, select InsertRow from the list, and click Options. See screenshot:
5. In the Macro Options dialog, press Shift and R keys together, then click OK to go back to Macro dialog.
6. Click Run to close Macro dialog. Now press Shift + Ctrl + R keys together will insert a blank row below the active cell.