increasing numbers in sreadsheet

  • Thread starter Thread starter luminore
  • Start date Start date
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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top