endless number range

[Matt]

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

 

[Dave Peterson]

Type 20000 in the top cell. Type 20001 in the next cell.

Use the autofill button to copy down as far as you want.

 

[Dana DeLouis]

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
= = = = = = = = = = = = = = = = =

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.