Excel > Excel 2007 Foundation > Managing Worksheets

Inserting and Deleting Rows, Columns and Cells

At times you will need to insert additional rows or columns into the worksheet, but you cannot exceed the maximum 1,048,576 rows and 16,384 columns per worksheet (mighty impressive, if you do).

Inserting rows on a worksheet

To insert new a new row:

  1. Select the row, or a cell in the row below where you want the inserted row to appear. For example, if you wanted to insert a row between rows 7 and 8, select row 8.
  2. Click Insert > Insert Sheet Rows from the Cells group of the Home tab.

Insert rows from the Cells group

To insert more than one row:

  1. Select the number of rows you would like to insert below where you want the inserted row to appear. For example, if you wanted to insert 3 rows between rows 7 and 8, select rows 8, 9 and 10.
  2. Click Insert > Insert Sheet Rows from the Cells group of the Home tab.

Inserting columns on a worksheet

To insert a new column:

  1. Select the column, or a cell in the column to the right of where you want the inserted column to appear. For example, if you wanted to insert a column between columns C and D, select column D.
  2. Click Insert > Insert Sheet Columns from the Cells group of the Home tab.

To insert more than one column:

  1. Select the number of columns you would like to insert to the right of where you want the inserted columns to appear. For example, if you want to insert 2 columns between columns C and D, select columns D and E.
  2. Click Insert > Insert Sheet Columns from the Cells group of the Home tab.

Inserting cells on a worksheet

To insert cells onto a worksheet:

  1. Select the cell, or the range of cells where you want to insert the new cells. Select the same number of cells as you would like to insert.
  2. Click Insert > Insert Cells from the Cells group of the Home tab.
  3. In the dialogue box that appears select the direction in which to shift the surrounding cells.

Shifting the surrounding cells on cell insertion

When you insert rows, columns or cells, any references to cells that are affected in the worksheet are adjusted accordingly.

Deleting rows, columns and cells

To delete rows or columns:

  1. Select the rows or columns to be deleted.
  2. Click Delete > Delete Sheet Rows or Delete Sheet Columns from the Cells group of the Home tab.
  3. The rows or columns are deleted and all other rows and columns are shifted up and to the left.

Deleting sheets rows and columns

To delete cells on a worksheet:

  1. Select the cell or cells to be deleted.
  2. Click Delete > Delete Cells from the Cells group of the Home tab.
  3. In the dialogue box that appears select the direction in which to shift the surrounding cells.

Delete cells dialogue box

Pressing the delete key only removes the contents from the cells and will not delete the rows, columns or cells.

When you delete rows, columns or cells, any references to cells that are affected in the worksheet are adjusted accordingly, unless it refers to a cell that has been deleted.

Follow us on

Facebook  Twitter  You Tube