Home / Computers / Microsoft Excel

Inserting Cells

Use the Insert command to insert a row, a column, or a blank cell into a worksheet.

To insert a row or column:

1. Select the row below, or the column to the right, of the location where you want the new row or column inserted.
2. Select Rows or Columns from the Insert menu, as appropriate. Or, right-click the row or column and select Insert from the shortcut menu.

A new, blank row or column is inserted. Note that it assumes the size and formatting of the adjacent row or column.

To insert a blank cell:

1. Select the cell adjacent to the location where you want to insert the new cell.
2. Select Cells from the Insert menu. Or, right-click the current cell and select Insert from the shortcut menu.

The Insert dialog opens.

3. Choose how you want to shift the existing cells to accommodate the new one.
4. Click OK.