Page 60 - Code & Click - 6
P. 60
To insert a new column in a worksheet: 1 2
1. Select the column heading
before which you want to insert
a new column.
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 2 3
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.
4. Select: 1
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.
5. Click the OK button. 4
Excel deletes the selected
cells.
5
Knowledge Discovery Subject Enrichment
The total number of rows and columns in a worksheet remains fixed even if you insert or delete rows or
columns.
58
