Excel Course: AutoFill series
Autofill often saves you a considerable amount of time because it prevents you from having to repeat the same operation over and over.
Start by entering the number 1, and the number 2 immediately below it, as shown here:
![selection excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/selection.png)
We're going to increment up to 20.
To do this, place the mouse pointer on the lower right hand corner of the selection, then click and drag downards until you see the number 20.
![fill cells excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/fill_cells.png)
Release the mouse button for the following result:
![filled cells excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/filled_cells.png)
Another way to achieve the same AutoFill: Enter the number 1 in A1:
![cell excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/cell.png)
If you do the same as in the previous example, you will see this result:
![fill cell excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/fill_cell.png)
Then choose "Fill Series":
![fill series excel autofill](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/fill_series.png)
AutoFill Series can also be applied to days, months, dates, times, etc.
Here is an example of this:
![cells selection excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/cells_selection.png)
The result:
![autofill view excel series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/autofill_view.png)
If you would like a different interval, do as shown immediately below:
![change interval excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/change_interval.png)
In this case, the result will be as in the image below:
- Increment A: 2 days
- Increment B: 2 months
- Increment C: months (instead of days)
- Increment D: 2 hours
- Increment E: + 2
- Increment F: + 10
![results autofill excel series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/results_autofill.png)
Example Using a Function
The selected cell contains the sum of the values shown in the frame.
![sum function excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/sum_function.png)
Now let's go ahead and do the AutoFill:
![autofill function excel series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/autofill_function.png)
The result is 2 new values, each of which is the sum of the values in its column:
![results autofill function excel series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/results_autofill_function.png)
AutoFill Formatting
Example of how to use Autofill for formatting, given the following 2 rows.
![rows excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/rows.png)
Just select and AutoFill the rows.
![selection 2 rows excel autofill series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/selection_2_rows.png)
This will be the result:
![autofill formatting excel series](https://www.excel-pratique.com/view/en/course/img/excel_autofill_series/autofill_formatting.png)
Exercise
Here is an exercise that will help you put everything you've learned in the first 5 lessons into practice: exercise5.xlsx