Home » Resources » Excel 2007 Tutorial » Time

AutoFill can also be used for Time.

Try this out by entering 1:00 into a cell and then drag your selection downwards using the little arrow in the bottom right of the selected cess as you did in the last sextion. You can also change the way that the time is displayed using the format box at the center of the ribbon:

Auto Fill can be used for any series of numbers. For this to work Excel needs a small starting series so that it can work out the rest of the sequence. For instance you can place numbers after text, and Excel will increase the number in each cell, but copy the text the same each time:

If you want a series of numbers that increases in larger increments (for instance 2,4,6,8,10), you’ll need to give Excel a helping hand by filling in the first couple of numbers in the list first. Try this by entering 2 in a cell, and 4 in the cell below it. Now highlight BOTH cells, and drag the auto-fill box down over more cells as before to continue the sequence going up by 2 each time.

Similar resources you may like

1. Auto Sum
2. Reference Operators
3. Calculating an Average
4. The Count Function
5. Auto Fill

Tags

auto fill, Excel, Excel 2007 Tutorial, excel training, excel tutorial, foramtting time, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:54 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.