Tuesday, December 14, 2010

Excel at EXCEL! Consecutive numbers, how do I prefill?

Excel:  Say you've got a list of consecutive numbers you need to enter, for instance, 23323, 23324, 23325 in Excel... you know there's a way to do it so here it is:
1.  Enter at least two of the numbers in your sequence
2.  Select the last two numbers you entered
3.  Position your cursor in the lower right corner of the cell of the last number you entered, until you see a PLUS sign
4.  Left click, hold down and drag down to prefill the consecutive numbers
Tune in tomorrow for a tip on organization and prioritizing!

No comments:

Post a Comment