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