Dynamic Numbered List creation

[bradwcampbell]

I have 800 cells that i would like to auto fill in

my base # is 2905000

I need to list range 2905001 - 2905800

I really dont want to type that number 800 times....

 

[T. Valko]

I have 800 cells that i would like to auto fill in

my base # is 2905000

I need to list range 2905001 - 2905800

I really dont want to type that number 800 times....

If you're using Excel 2007 or later...

Let's assume you want the sequence filled starting in cell A1 down to A800.

Enter 2905000 in cell A1

With cell A1 still selected...

• Goto the Home tab>Editing group>Fill
• Series
• Columns
• Stop value: 2905800
• OK

 

[bradwcampbell]

nice ..

Thanks

 

[T. Valko]

nice ..

Thanks

You're welcome!