Inserting Rows and Columns

You may find you need to add rows or columns of new information into the middle of your workbook. Excel makes it easy to add new columns and rows to your workbook.



To insert a row:

  1. Place your cursor in a cell in the row below where you want the new row.
  2. Click Rows on the Insert menu.



To insert a column:

  1. Place your cursor in a cell in the column to the right of where you want the new column.
  2. Click Columns on the Insert menu.


When you insert a row or column, a smart tag will appear. Click the smart tag to choose formatting options—Same as left, Same as right, or Clear Formatting.

You can also insert rows and columns from the Insert dialog box:

  1. Right-click in a cell, then click Insert....
  2. In the Insert dialog box, choose Entire row or Entire column.
  3. Click OK.