autonumbers

[meadhbh2005]

Hi does anyone know if there is a way of inserting numbers into excel so they automatically increment. eg i want to number my rows but do not want to do it manually...?

Thanks

 

[sykes]

Hi, and welcome to Mr Excel

If you use the formula:

=ROW()

It will make the value of the cell the same as the row number.
You can then use the fill handle to fill down.

If, however, you wanted a different series, just reference a cell with the start number you wish for, so if you want to begin numbering with a 1 in A6, you could use in A6:

=ROW(A1)

Then fill down.

Did I understand your question correctly?

 

[BBHRVS]

Welcome to the board !

could you precise a little bit more your needs ?

Do you want to feed manually ?
In this case, you enter the 2 first figures, select the two cells and drag them down. Excel will increment automatically.
Do you want a formula ?
Do you want to feed form a macro ?
Then it will be a loop such as :
activesheet.cells(1,1)=1
For i=1 to xxx 'if you begin at row 1
activesheet.cells(i,1)=activesheet.cells(i-1,1)+1 'if you work on column 1
Next

Bur a more precise macro can be designed only with more precise info.

 

[sykes]

............ there again, if you just want a plain series of numbers, put your start number in your start cell, and use the fill handle to fill down..........