View Single Post
  #3   Report Post  
Sandy Mann
 
Posts: n/a
Default

Or you can enter 1 in A2, 2 in A3, highlight both cells and copy down using
the fill handle to give you a list. The problem with both this and Paul's
method is that if you insert a row you end up with a hole in the numbering.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Javster95" wrote in message
...
Is there a way to automatic number a spreadsheet? For instances... if I

were
to start on column A and row 2 with number 1, would this be possible to
continue numbering going down the spreadsheet? Please assist.