Using Autofill in Excel - Image Tutorial

Autofill help you avoid repetitive work and significantly increase productivity. If someone searched for "How do I stop doing this useless repetitive work in Excel?", in an ideal world, this page would show up. You will soon see what I mean.

How to Autofill a Number Series:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on cell A1.
3. Type in a "1". (no quotes)




4. Click on cell A2.
5. Type in a "2".




6. Click on cell A3.
7. Type in a "3".




8. Highlight Cells A1, A2, A3. (Now I need you to make the series go all the way to 20)
   To highlight A1 to A3 you can place your pointer over A1,
   click and hold the left mouse button then drag over A3 and release the button




9. Now you will see a box on the bottom right corner of the highlighted cells. Move your pointer over it until it turns into a little black "+".
10. Left Click and hold the left mouse button.




11. Drag the box all the way down to A20.




12. You should now have 1 to 20 in column A. Amazing isn't it?

How to Autofill a Days of the Week Series:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on cell A1.
3. Type in a "Monday". (no quotes)




4. Click on cell A2.
5. Type in a "Tuesday".




6. Click on cell A3.
7. Type in a "Wednesday".




8. Highlight Cells A1, A2, A3. (Now we want to finish the week)
   To highlight A1 to A3 you can place your pointer over A1,
   click and hold the left mouse button then drag over A3 and release the button




9. Now you will see a box on the bottom right corner of the highlighted cells. Move your pointer over it until it turns into a little black "+".
10. Left Click and hold the left mouse button.




11. Drag the box all the way down to A7.




12. You should now have Monday to Sunday in column A.

How to Autofill a Date Series:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on cell A1.
3. Type in a "01-Jan-08". (no quotes)
4. Click on cell A2.




5. Type in a "02-Jan-08".
6. Click on cell A3.




7. Type in a "03-Jan-08".



(Curious what happens when you get to 32?)
8. Highlight Cells A1, A2, A3.
   To highlight A1 to A3 you can place your pointer over A1,
   click and hold the left mouse button then drag over A3 and release the button




9. Now you will see a box on the bottom right corner of the highlighted cells. Move your pointer over it until it turns into a little black "+".
10. Left Click and hold the left mouse button.




11. Drag the box all the way down to A32.




12. You should now have January 1st to February 1st in column A.

How to Autofill a String Series:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on cell A1.
3. Type in a "this". (no quotes)




4. Click on cell A2.
5. Type in a "is".




6. Click on cell A3.
7. Type in a "great".




8. Highlight Cells A1, A2, A3.
   To highlight A1 to A3 you can place your pointer over A1,
   click and hold the left mouse button then drag over A3 and release the button




9. Now you will see a box on the bottom right corner of the highlighted cells. Move your pointer over it until it turns into a little black "+".
10. Left Click and hold the left mouse button.




11. Drag the box all the way down to A9.




12. You should now have the sequence repeated 3 times in column A.

If you had any problems completing this module or think some details need more explanation, please let us know. We also welcome any other feedback.
Send Feedback