Insert Cells Dialog

The Insert Cells dialog is used to add a cell, a range of cells, a new row or new column to the spreadsheet.

Click a cell or a range of cells in which you would like to insert a new cell, a range of cells, a new row or a new column.
From the Insert menu, click Cells.
Select the appropriate insert action:
- Shift cells right: Inserts the new cells to the left of the selected cell(s). Select the same number of cells that you want to insert.
- Shift cells down: Inserts the new cells above the selected cell(s). Select the same number of cells that you want to insert.
- Entire row: Inserts an entire row of cells. 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.
- Entire column: Inserts an entire column of cells. 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.
Click OK to insert the cell(s), row or column.