Page 81 - Computer - 6

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.

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.
A drop-down list appears. 1

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

Excel deletes the selected row or column.

Knowledge Discovery Subject Enrichment

If you select row heading or column heading and press the Delete key, Excel only deletes the content of
the row or column and not the entire row or column.

CHANGING ROW HEIGHT AND COLUMN WIDTH
Sometimes the contents of the cells exceed the cell boundaries and are
not visible clearly. You can change the height of rows or width of columns
to view the contents of such cells properly. 2
The row height or column width can be adjusted by: 3
• Using the Format option on the Ribbon • Dragging the heading boundaries
To change row height:
1. Select the row whose height you want to change.
2. On the Home tab, click the Format down
arrow in the Cells group. 1
A drop-down list appears.
3. Select the Row Height... option.
The Row Height dialog box opens.
4. Specify a value in the Row height text box.

79