Page 59 - Code & Click - 6

INSERTING CELLS, ROWS, OR COLUMNS

To insert a new cell in a worksheet: 1 2 3
1. Select the location where you
want to insert a new cell.
2. On the Home tab, click the
Insert down arrow in the
Cells group.
A drop-down list appears.

3. Select the Insert Cells... option.
The Insert dialog box opens.
4. Click:

to insert a new cell at the selected location and shift the existing cells
Shift cells right
towards right

Shift cells down to insert a new cell at the selected location and shift the existing cells down.

4 5. Click the OK button.
Excel inserts a new cell at the
desired location.

5

2
To insert a new row in a worksheet:
1. Select the row heading before
which you want to insert a new
row.
2. On the Home tab, click the Insert
down arrow in the Cells group.
A drop-down list appears. 1
3

3. Select the Insert Sheet Rows option.

Excel inserts a new row before the selected row.

57