how to generate a range of number

  • Thread starter Thread starter Vito Corleone
  • Start date Start date
V

Vito Corleone

Howdy folks,

I would like to know how to generate a range of number
(for example: 10000 to 19999) in excel without typing them
in each number into each cell one by one.

Your help would boot up my business significantly.

Gracias,

Vito Corleone,
President
 
One way:

Enter 10000 in A1. Choose Edit/Fill/Series. Select the Columns and
Linear radio buttons, with a Step value of 1. Enter 19999 in the Stop
Value box and click OK.
 
in cell A1 enter 10000
in cell B1 enter =A1+9999 and copy down the column
in cell A2 enter =B1+1 and copy down the column
 
Back
Top