In this topic, we will use the **Auto Fill** feature in Excel.

Use the** Auto Fill **feature to fill cells with data that follow a certain sequence.

Steps:

**Numbers:**

Step 1**Auto Filling a Sequence of Numbers**.Click in the first cell.

Step 2Type the first number in your sequence. In this example, we'll enter the number 1.

Step 3Click in the second cell.

Step 4Enter the second number in your sequence. In this example, enter the number 2.

Step 5Highlight the Cells containing the numbers.

Click the

Step 6**Auto Fill**handle (lower right hand corner of the cell) and drag down.Your results:

Step 7**Numbers:****Auto Filling a Series of Numbers or Characters.**

Step 8Click in the first cell.

Step 9Type the first number (or character) of the series. In this example, type the number 3.

Step 10Click the next cell.

Step 11Enter the next number (or character) in the series.

In this example, enter the number 6.

Step 12Click the next cell.

Step 13Enter the number 9.

Step 14Highlight the Cells containing the numbers.

Hold the

Step 15**[Ctrl]**key on your keyboard, click the**Auto Fill**handle, and drag down.Your results:

Step 16

After completing this topic, you are familiar with the** Auto Fill** feature in Excel.