Page 69 - TGPT_V5.0_C5_Flipbook
P. 69
DELETING CELL CONTENTS
To delete the contents of a cell or a range of cells, select the cells and press the Delete key. The
contents of the cells get deleted.
Deleting Cells
To delete cells, follow the given steps:
Select the cell or range of 1 Click on Delete drop-down 2
cells and click on Home tab. arrow.
Click on Delete 3
Cells option.
Click on the radio button
in front of Shift cells left 4
option.
5
Click on OK button.
It deletes the selected
cells. The cells on the right
It deletes the selected cells. are shifted to the left.
The cells below, shift up.
It deletes the selected column. It deletes the selected row.
The columns on the right are The row below, shifts up.
shifted to the left.
Deleting an Entire Row or Column
To delete an entire row or column, follow the given steps:
2 3
Click on Home tab. Click on Delete drop-down arrow.
Select the Delete
Sheet Rows or
Delete Sheet 4
Column.
Click on the row or column header of 1
the row or column you have to delete.
Introduction to Excel 2021 67

