Auto Fill Numbers


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:

  1. Numbers:

     

    Auto Filling a Sequence of Numbers.

    Step 1
  2. Click in the first cell.

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

    Step 3
  4. Click in the second cell.

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

    Step 5
  6. Highlight the Cells containing the numbers.

     

    Click the Auto Fill handle (lower right hand corner of the cell) and drag down.

    Step 6
  7. Your results:

    Step 7
  8. Numbers:

     

    Auto Filling a Series of Numbers or Characters.

     

    Step 8
  9. Click in the first cell.

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

    Step 10
  11. Click the next cell.

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

    In this example, enter the number 6.

    Step 12
  13. Click the next cell.

    Step 13
  14. Enter the number 9.

    Step 14
  15. Highlight the Cells containing the numbers.

     

    Hold the [Ctrl] key on your keyboard, click the Auto Fill handle, and drag down.

    Step 15
  16. Your results:

    Step 16

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