Insert Blank Rows or Columns

As you work with a new spreadsheet or modify an existing one, you may find it necessary to insert a row or column.

To insert a row:

1. Click on a row or a single cell directly beneath the location where the additional row is needed. (Note: The new row will insert directly above the cell or row you have selected.)
2. Navigate to the Home Tab/Cells Group/Insert Cell drop down arrow.
3. Choose Insert Sheet Rows.

To insert multiple rows at one time:

1. Select the equivalent number of rows that you want inserted. For example, if you wish to insert 3 rows, highlight 3 rows. (Note: The new rows will insert directly above the rows you have selected.)
2. Select Insert from the Home Tab/Cells Group.
3. Choose Insert Sheet Rows.

To insert a column:

1. Click on a column or a single cell immediately to the right of the location the additional column is needed. (Note: The new column will insert directly to the left of the cell or column you have selected.)
2. Select Insert from the Home Tab/Cells Group.
3. Choose Insert Sheet Columns.

To insert multiple columns at one time :

1. Select the equivalent number of columns that you want inserted. For example, if you wish to insert 3 columns, select 3 columns. (Note: The new columns will insert directly to the left of the cell or column you have selected.)
2. Select Insert from the Home Tab/Cells Group.
3. Choose Insert Sheet Columns.