Insert blank cells, rows, or columns

1. Do one of the following:

   Insert new blank cells    Select a range of cells where you want to insert the new blank cells. Select the same number of cells as you want to insert.

   Insert a single row  Click a cell in the row immediately below where you want the new row. For example, to insert a new row above row 5, click a cell in row 5.

   Insert multiple rows  Select rows immediately below where you want the new rows. Select the same number of rows as you want to insert.

   Insert a single column  Click a cell in the column immediately to the right of where you want to insert the new column. For example, to insert a new column to the left of column B, click a cell in column B.

   Insert multiple columns  Select columns immediately to the right of where you want to insert the new columns. Select the same number of columns as you want to insert.

2. On the Insert menu, click Cells, Rows, or Columns.
3. If you are moving or copying a range of cells, and not a row or column, in the Insert Paste dialog box, click the direction to shift the surrounding cells.

Tip

If there is formatting, you can use Insert Options to choose how to set the formatting of the inserted cells, rows, or columns.