autonumbers

meadhbh2005

New Member
Joined
Dec 13, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Nov 3, 2005
Messages
94
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

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
............ 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..........
 

Watch MrExcel Video

Forum statistics

Threads
1,118,009
Messages
5,569,596
Members
412,281
Latest member
GraYmOnD0808
Top