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...?
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:
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.
............ 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..........