See all How-To Articles

How to Insert Multiple Rows / Columns in Excel & Google Sheets

This tutorial will demonstrate how to insert multiple rows and columns in Excel and Google Sheets.

 

RowColumns Insert

 

By selecting multiple rows or columns in Excel, you can quickly insert several new blank rows or columns. This tutorial covers how to insert cells with the right mouse button or the Excel Ribbon. To learn how to use VBA to insert cells, see VBA Insert Row or Column.

Insert Multiple Adjacent Rows

To insert multiple adjacent blank rows into a worksheet, select the number of rows you wish to insert into your worksheet at the position where you wish to insert the rows. The rows selected will be moved down by the selected number of blank rows inserted. (e.g., existing Row 4 becomes Row 7).

 

RowsColumns SelectMultipleRows

 

Right-click on the row headers to obtain the Quick Menu and click Insert.

 

RowsColumns InsertMultipleRows RightClick

 

OR

In the Ribbon, select Home > Cells > Insert > Insert Sheet Rows.

 

RowsColumns InsertMultipleRows Ribbon

 

OR

To use a keyboard shortcut, press Ctrl +

Three additional rows will quickly be inserted into to the worksheet all at once.

Inserting Multiple Non-Adjacent Rows

To insert multiple non-adjacent blank rows into a worksheet, select the first row you where you wish your new row to be inserted by clicking on the row selector, and then, holding down the Ctrl key, select the next non-adjacent row.

RowColumns NonAdjacent rows

You can then use the methods above (Quick menu insert; Insert Sheet Rows or Ctrl+) to insert non-adjacent rows into your worksheet.

Inserting Multiple Adjacent Columns

To insert multiple blank columns into your worksheet, select the number of columns you wish to insert into your worksheet at the position that you wish to insert columns. The columns selected will be moved to the right.

RowColumns Ribbon djacent

 

Right-click on the row headers to obtain the Quick Menu and then click Insert.

 

RowsColumns InsertMultipleColumns RightClick

 

OR

In the Ribbon, select Home > Cells > Insert > Insert Sheet Columns.

RowColumns ribbon insert

 

OR

To use a keyboard shortcut, press Ctrl +

Three additional columns will quickly be inserted into your worksheet all at once.

Inserting Multiple Non-Adjacent Columns

To insert multiple non-adjacent blank columns into a worksheet, select the first column you where you wish your new column to be inserted by clicking on the row selector, and then, holding down the Ctrl key, select the next non-adjacent column.

RowColumns Ribbon nonadjacent

You can then use the methods above (Quick menu insert; Insert Sheet Rows or Ctrl+) to insert non-adjacent columns into your worksheet.

Insert Cells in Google Sheets

You can use the right-click option in Google sheets to quickly insert rows or columns into your sheet as well.

Insert Multiple Rows

Select the rows where you wish to insert the extra rows into your sheet.

 

RowColumns GS SelectRows

Right-click on the row headers.

 

RowColumns GS Rows Insert RightClick

 

OR

In the Menu, select Insert.

 

RowColumns GS Rows Insert_Menu

 

In both instances, you are given the options to insert the new blank rows either above or below the highlighted rows. Select the option required and your rows will quickly be inserted into your worksheet.

 

RowColumnsGS RowsInserted

 

Insert Multiple Columns

You can insert multiple columns in the same way, either by right-clicking on the column headers, or by using the Insert option on the Menu.

Select the columns where you wish the new columns to be inserted.

 

RowColumns Gs SelectColumns

 

Right-click on the column headers.

 

RowColumns_Gs Columns Insert RightClick

 

OR

In the Menu, select Insert.

 

RowColumns GS Columns Insert Menu

 

As with inserting rows, in both instances, you are given the option to insert the same number of columns as the number of columns you have highlighted either to the left or right of the highlighted columns .

 

RowColumns Gs ColumnsInserted