Page 71 - TP_Plus_v4_Class4
P. 71
Select the cell or range of 1
cells and click on Home tab. Click on Delete down arrow. 2
Click on Delete 3
Cells option.
Choose an option by
clicking any one radio 4
button.
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 down arrow.
Select the Delete
Sheet Rows or
Click on the Delete Sheet
row or column Columns. 4
header of the
row or column
1 you have to
delete.
USING AUTOFILL FEATURE
The AutoFill feature in Excel is used to automatically fill a series of data in
rows and columns based on the values of selected cells. You can use the
AutoFill feature to fill a series of numbers, days, months, hours, etc.
In Excel, when you hover your mouse on the bottom right corner of the
selected cell or range, the pointer changes to a plus sign. This is called the
Fill Handle.
#Editing Cell Contents in Excel 2019 69

