how to generate a range of number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vito Corleone - 14 Jul 2004 23:09 GMT

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

Reply to this Message

JE McGimpsey - 14 Jul 2004 23:20 GMT

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.

> Howdy folks,
>
[quoted text clipped - 8 lines]
> Vito Corleone,
> President

Reply to this Message

Trevor - 16 Jul 2004 19:02 GMT

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

> Howdy folks,
>
[quoted text clipped - 8 lines]
> Vito Corleone,
> President

Reply to this Message