Incremental Numbering of a Column

[Guest]

We have a spreadsheet that we want the first column to automatically change
the cell under it one digit higher..

for example

300
301
302
303
....

How can this be done for a column in Excel? What is the formula if there is
one to do this?

If this is the wrong newsgroup sorry.. not sure where to post the question..

Thanks...

 

[Guest]

Insert the formula =ROW() in all cells in the target column
OR type the starting value of the counter in a cell, say, A1
Then type =A1+1 in the cell below, then copy this formula to all cells in
that column.

If you want just the cell in the row below to be changed and no further rows
to be changed, you would need to use an event such as
Worksheet_SelectionChange and write the code in its handler: he code can be
messy.

 

[Frank Kabel]

Hi
use for example in cell A1
=ROW()+299
and copy this down