Page 56 - Code & Click - 6

Using AutoComplete Feature

The AutoComplete feature in Excel allows you to quickly enter similar text in different cells of the
same column.

To use AutoComplete feature:
1. Type the first few characters of the required text in a cell.
As you type, Excel automatically suggests the remaining
characters based on the text you have entered earlier in the
same column.
2. Press the Enter key to accept the AutoComplete suggestion
else, type the required text. 1

Using AutoFill Feature
The AutoFill feature in Excel allows you to quickly fill a range of cells with a series of data without
typing each value one by one. You can use the AutoFill feature to copy data in a cell range or fill a cell
range with a series of numbers that follows a particular pattern.
To copy data in a cell range:
1. Click a cell and type the data you want to copy in other cells.
2. Move the mouse pointer over the small square, at the bottom-right of the selected cell, called
the Fill handle.

1 3

2
4

The mouse pointer changes to a thin black plus sign +.
3. Drag the fill handle down to fill a vertical range of cells or across
to fill a horizontal range of cells.
4. Release the mouse button when you reach the end of the desired
range of cells.
Excel copies the data in the desired cell range.

To fill a cell range with a series of numbers that follows a
particular pattern: 1 3
1. Click a cell and type the first value of the series. 2

2. Click the next consecutive cell and type the second
value of the series.

3. Select both cells.
4. Drag the fill handle down to fill a vertical range of

cells or across to fill a horizontal range of cells. 4
As you drag through each cell, Excel displays the 5

value that it will add to the cell.

54