Increasing numbers.

P

pawnraider

I'm trying to number cells but the way I would like to do it is in the
adjoining cell it will be the next number. Y'know like 1,2,3,4 and so on. I
have two books on Excel but I can't find that info. Thanks for the help.
 
B

Bernard Liengme

In A1 type 54
In A2 use =A1+1
Copy down the column

OR of use the automatic fill feature: type numbers in A1 and A2, select and
drag down the column

OR use Edit | Fill

best wishes
 
M

Max

Maybe something like this
Assume data will be sequentially entered in B2 down
Put in A2: =IF(B2="","",ROWS($1:1))
Copy A2 down to cover the max expected extent of data entry in col B, eg
down to A100. Col A will return the serial numbering in tandem with the data
entry in col B

If above helps, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 
Top