Page 61 - Code & Click - 6

To delete a row or column from a worksheet: 2 3

1. Select the row heading or column
heading you want to delete.

2. On the Home tab, click the Delete
down arrow in the Cells group.

1

3. Select the Delete Sheet Rows or Delete Sheet Columns
option.

CHANGING ROW HEIGHT AND COLUMN WIDTH
To change row height: 2

1. Select the row whose height you want to change. 3

1

2. On the Home tab, click the Format down arrow in the Cells group.

3. Select the Row Height... option.
The Row Height dialog box opens.
4. Specify a value in the Row height text box.

5. Click the OK button.

4
5 2

Excel changes the row height to the specified value.

To change column width: 3
1. Select the column whose width you want to change.

1

59