Page 80 - Computer - 6

To insert a new row in a worksheet: 2
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.

1 2

To insert a new column 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.
3
3. Select the Insert Sheet Columns option.

Excel inserts a new column before the selected column.

DELETING CELLS, ROWS, OR COLUMNS

You can delete cells, rows or columns from a 2 3
worksheet which are not required anymore.
To delete cells from a worksheet:

1. Select the cells you want to delete.

2. On the Home tab, click the Delete
down arrow in the Cells group.
3. Select the Delete Cells... option from

the drop-down list.

The Delete dialog box opens. 1
4. Select:

Shift cells left to delete the selected cell and shift the existing cells towards left.

Shift cells up to delete the selected cell and shift the existing cells up.

78