Insert a row

How to insert a single row in a worksheet using Excel, VBA and Shortcut methods

METHOD 1. Insert a row by selecting an entire row

EXCEL

Select an entire row > Right-click anywhere on the selected row > Click Insert

1. Select an entire row where you want to insert a new row.
Note: in this example we are inserting a new row as a second row. To select an entire row, click either on the row heading number or select the first cell of the row, press and hold the Ctrl and Shift keys and press the Right key.
Select entire row

2. Right-click anywhere on the selected row and click Insert. Right-click and click Insert

METHOD 2. Insert a row using the ribbon option

EXCEL

Select a cell in the row where you want to insert a new row > Home tab > Cells group > Insert > Insert Sheet Rows

1. Select any cell in the same row where you want to insert a new row.
Note: in this example a new row will be inserted as row 2, given we have selected a cell in the second row.
Select a cell in the same row where you want to insert a new row

2. Select the Home tab. Select Home tab - Excel

3. Click Insert in the Cells group.
4. Click Insert Sheet Rows.
Click Insert and click Insert Sheet Rows

METHOD 3. Insert a row using the cell option

EXCEL

Right-click on a cell in the row where you want to insert a new row > InsertEntire row > OK

1. Right-click on any cell in the row where you want to insert a new row.
2. Click Insert
Note: in this example a new row will be inserted as row 2, given we have right-clicked on a cell in the second row.
Right click on a cell and click Insert

3. Select the Entire row option and click OK group. Select Entire row and click OK

METHOD 1. Insert a row using VBA by selecting a single cell

VBA

Sub Insert_a_Row()
'insert a new row as row 2
Worksheets("Sheet1").Range("A2").EntireRow.Insert

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.

ADJUSTABLE PARAMETERS
Row Selection: Select where you want to insert a new row by changing the row number in the cell reference ("A2"). You can also change the column reference to any column as this will have no impact on where the row will be inserted.
Worksheet Selection: Select the worksheet where you want to insert a new row by changing the Sheet1 worksheet name.

METHOD 2. Insert a row using VBA by selecting a range of cells

VBA

Sub Insert_a_Row()
'insert a new row as row 2
Worksheets("Sheet1").Range("A2:D2").EntireRow.Insert

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.

ADJUSTABLE PARAMETERS
Row Selection: Select where you want to insert a new row by changing the row number reference ("A2:D2"). You can also change the column reference to any column as this will have no impact on where the row will be inserted.
Worksheet Selection: Select the worksheet where you want to insert a new row by changing the Sheet1 worksheet name.

METHOD 3. Insert a row using VBA by selecting an entire row

VBA

Sub Insert_a_Row()
'insert a new row as Row 2
Worksheets("Sheet1").Range("2:2").EntireRow.Insert

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.

ADJUSTABLE PARAMETERS
Row Selection: Select where you want to insert a new row by changing the row number reference ("2:2").
Worksheet Selection: Select the worksheet where you want to insert a new row by changing the Sheet1 worksheet name.

Insert a row using a Shortcut

SHORTCUT

WINDOWS SHORTCUT
Method 1

Ctrl
Shift
+

Method 2

Ctrl
+

NOTES

To insert a row using these shortcut methods you will need to select an entire row. If you select a single cell or a range of cells and action this shortcut an Insert dialog box will appear and you will need to select Entire row and click OK.

The Plus Sign key in the first method refers to the key on the top of the keyboard. The Plus Sign key in the second method refers to the key to the right of the keyboard, which some devices will not have. The reason why the first method requires the use of the Shift key is because the Plus Sign key is used for both Plus and Equal Signs, therefore, to activate the Plus Sign you are required to use the Shift key.

Explanation about how to insert a row

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to insert a single row in a worksheet using Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can insert a new row by selecting an entire row or a single cell and using a ribbon or cell option.

VBA Methods: Using VBA you can insert a new row by referencing to a single cell, a range of cells or an entire row. If you want to insert a single row by referencing to a range of cells you need to ensure that the range of cells only references to a single row. As per the example in this tutorial the VBA code references to only row 2 across multiple columns ("A2:D2").

Shortcut Methods: Using a Shortcut you can instantly insert a new row by selecting the entire row where you want to insert a new row and actioning the shortcut.

ADDITIONAL NOTES
Note 1: Inserting a new row will move the existing rows that are below the new row downward. In this this tutorial every row below row 2 will be moved down.
Note 2: If the last row in a worksheet has a cell that is not empty, you will not be able to insert a new row. To insert a row you will need to ensure that every cell in the last row is clear of any content.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to insert a single column in a worksheet using Excel, VBA and Shortcut methods
How to delete a single column in a worksheet using Excel, VBA and Shortcut methods
How to delete multiple columns in a worksheet using Excel, VBA and Shortcut methods
How to insert multiple columns in a worksheet using Excel, VBA and Shortcut methods
How to insert multiple rows in a worksheet using Excel, VBA and Shortcut methods