Page 53 - 2617_JSSPS_C-5

Deleting an Entire Row or Column

To delete an entire row or column, follow the given steps:

Click on Delete
Click on 3
2 Home tab. drop-down arrow.

Click on the
row or column Select the
header of the Delete Sheet
row or column Rows or Delete
1 you want to Sheet Columns 4
delete. option.

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 other 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 (+) sign. This feature is called
Fill Handle. To fill a series using the Fill Handle, drag the plus (+) sign to the
desired cell. To use the Autofill feature, follow the given steps: Fill Handle

Type the first Click on Fill button. 3
number in a
1
series.

Select the cell Click on Series
and the cells option. 4
2 that you want
to AutoFill.

You can also change or select other values.

Enter the Stop 5

6 Click on OK value.
button.

Introduction & Editing in Excel 51