endless number range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to insert an endless number range beginning from 20000 to the end of the spreadsheet. of course I do not want to type them all in by myself. How con I do that.

Thanks for your advic
MAtt
 
Type 20000 in the top cell. Type 20001 in the next cell.

Use the autofill button to copy down as far as you want.
 
Another option is to insert 20000 into a cell, and then do <Edit> <Fill>
<Series...>
Select "Series in Columns","Linear", "step value of 1."
Select a large Stop value of say 90000 or greater.

The only "very slight" advantage of doing it this way is that the algorithm
keeps more of the numbers as integers. It introduces less floating point
errors than dragging down.

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


Matt said:
I want to insert an endless number range beginning from 20000 to the end
Click to expand...
of the spreadsheet. of course I do not want to type them all in by myself.
How con I do that.
 
Back
Top