NUMBERING ROWS
 

hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc

any help willbe brilliant

thanks
--
CRUSTY

NUMBERING ROWS
 

One guess ..

Suppose the initial row number will be entered in A1, eg in A1: 1
Put in A2: =IF($A$1="","",A1+1)
Copy A2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CRUSTY" wrote:
hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc

any help willbe brilliant

thanks
--
CRUSTY

NUMBERING ROWS
 

Hold the Ctrl key and drag the Fill handle down as far as needed


"CRUSTY" wrote:

hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc

any help willbe brilliant

thanks
--
CRUSTY