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
 
You must log in or register to reply here.

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

Similar Threads

How to subtract a number from a Mergefield? 0
Combining sumIF statements with other functions? 2
generate unique random numbers 7
Deleting rows that contain numbers (a range) in column D 7
VBA set thick borders around non empty cells in range 0
Count in a range of numbers 8
Naming ranges on multiple worksheets 3
Creating independant Arrays of sequential numbers 1

Back
Top