Build a sequence of numbers, text or dates quickly

You can build a sequence of numbers, text or dates within excel very quickly.  Simply enter the sequence you want to repeat as the example below:

5
10

Now drag over the two or more cells containing the pattern of sequence you want to create and select the black fill handle at the bottom right and drag down to create a sequence as below:

5
10
15
20
25
30
And so on …

VIDEO TIP BELOW



Leave a Reply