June 19, 2009, Newsletter Issue #312: Extending numerical sequences in Excel

Tip of the Week

If you need to enter numerical sequences that follow a logical order (such as 1, 2, 3 or 5, 10, 15), Excel can save you a great deal of time and trouble.

If you enter the first two numbers, Excel can complete the series for you.

If you enter 1 in cell A1 and 2 in cell B1 and select both cells with the mouse. Then click and drag the fill handle to the right. Excel will continue the series as far as you drag.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!

Guru Spotlight
Patricia Walters-Fischer