# 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.

## To Display the Insert Cells Dialog

1. 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 new column.

2. Right-click the cell(s) that you want to insert additional cells, row or column near and select Insert from the right-click menu.

3. Once you have decided upon how you would like the additional cell(s), row or column added, click OK to insert the cell(s), row or column.

## Insert Cells Dialog Controls

- Shift cells right: Inserts the new cells to the left of the selected cell(s). Select the same number of cells as you want to insert.
- Shift cells down: Inserts the new cells above the selected cell(s). Select the same number of cells as 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.