Excel insert row below shortcut
We will explain how to insert a row under the currently selected cell. First, Excel does not have the ability to insert a new row under the active cell. However, if you use VBA and enter the right code, you can insert a row under the currently selected cell. It is also possible to create a shortcut key to insert a row below using VBA.
Insert a row below the active cell using VBA
This section describes how to use the VBA to insert a row below.
Total Time: 5 minutes
Select a cell
Select the cell where you want to insert the row below.
Select View Code
Right-click on the current Sheet Tab and select View Code.
Select a module
Microsoft Visual Basic for Applications is now displayed. Select the Insert tab, and then select the module.
Enter the code
Copy and paste the following code into the module.
Sub InsertRowBelow() ActiveCell.Offset(1).EntireRow.insert End Sub
Select Run Sub
Select Run Sub, or press F5.
Select View Microsoft Excel
Select View Microsoft Excel, or press Alt + F11.
Inserted a row below
A row has been inserted below the active cell.
Register a shortcut to insert a line below
Explains how to assign shortcut keys to the VBA you have created.
Select the cell where you want to insert a row below and press Alt + W + M + V.
The Macro dialog box will appear.
Select InsertRowBelow, and then select Options.
The Macro Options dialog box will appear.
Enter a key to be registered as a shortcut key. Here, as an example, we enter B in the shortcut key entry field and press Enter.
Press Ctrl + Shift + B to insert a row down.