Insert blank cells, rows, or columns

Microsoft Office Excel 2003

previous page next page
  • 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.

  • On the Insert menu, click Cells, Rows, or Columns.
  • 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.

    • ShowTip

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

    previous page start next page