Excel Hack

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 a cell

Select the cell where you want to insert the row below.

Select View Code

Select View Code

Right-click on the current Sheet Tab and select View Code.

Select a module

Select a module

Microsoft Visual Basic for Applications is now displayed. Select the Insert tab, and then select the module.

Enter the code

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

Select Run Sub, or press F5.

Select View Microsoft Excel

Select View Microsoft Excel

Select View Microsoft Excel, or press Alt + F11.

Inserted a row below

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 a cell

Select the cell where you want to insert a row below and press Alt + W + M + V.

Select option

The Macro dialog box will appear.

Select InsertRowBelow, and then select Options.

enter B

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.

Inserted a row below

Press Ctrl + Shift + B to insert a row down.