For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart


Auto Fill

/ home / blog /Auto Fill

Written by Andy Trainer– Wed 06 May 2009

Excel's Auto Sum feature is a handy time-saving feature that prevents you having to type out lists of commonly used values like sequences of numbers, days of the week or months. Auto Sum is covered in our Excel Beginners Training Course.

Written Instructions

Let's demonstrate this with months. Type "January" in to a cell in your spreadsheet. Highlight the cell and you'll see that there's a little black arrow in the bottom right hand corner. Carefully click on this arrow with the mouse (a bit fiddly!) and hold the button. Now drag the box downwards a few cells and release, and Excel will fill in the subsequent months for you. Clever eh! Even better, it will also recognise abbreviations, such as Jan, Feb, Mar etc...

Excel Auto Fill Example

When you have finished dragging you will also see an Auto Fill options box appear.

Excel Auto Fill Options bar

If you click on this a drop down menu will appear showing you a list of further options. Whatever you press in this drop down menu will affect the series of numbers that you have created. If you would rather not have Excel type out all of the months and want all of the cells to say January, use the “copy cells” option

Posted under:

blog comments powered by Disqus

Looking for Online Training?

AgilePM, PRINCE2® & MSP® eLearning

A flexible, cost-effective way to gain your AgilePM, PRINCE2 & MSP qualifications online with our APMG accredited AgilePM eLearningPRINCE2 eLearning & MSP eLearning packages.

ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.