Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.
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.
|Sheri Ann Richerson|