increasing numbers in sreadsheet

L

luminore

I need prepare full list with numbers, starting from 129680 and up to
129779 (in some column):

129680
129681
129682
....
129779

what is formula?
 
P

Pete_UK

If you want a formula solution, enter your first number in A1 then in
A2 enter:

=A1+1

then copy this down for as many cells as you require. Alternatively you
can fill the values down - enter your first value in A1, then highlight
cells from A1 down (as many as you need - hold down <SHIFT> while
pressing <PageDown>, then release <SHIFT>), then Edit | Fill | Series
and specify Linear with a Step Value of 1, click OK.

Hope this helps.

Pete
 
A

Arvi Laanemets

Into 1st cell enter 129680, into 2nd 129680, select both cells, hook them
with mouse (point at lower roght corner of area, and hold down left mouse
button so, that cursor changes to cross) and drag down.
 
Top