Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Numbering
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. |
#2
|
|||
|
|||
Javster. you could grab the fill handle, the little black square in the
bottom right hand, right click and drag down and fill series or put = A2 +1 in A3 and copy down -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
...................................... 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. That being the case you would be better with: =ROW()-1 in A2 and copied down. You will still get a hole in the numbers if you insert a new row but now at least all youhave to do is to drag down the formula from the row above. HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... 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. |
#5
|
|||
|
|||
You could dodge that as well with
=ROW()-ROW($B$2)+1 where B2 represents the cell where you'd put the formula, this will adapt to inserted rows -- Regards, Peo Sjoblom "Sandy Mann" wrote in message ... ...................................... 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. That being the case you would be better with: =ROW()-1 in A2 and copied down. You will still get a hole in the numbers if you insert a new row but now at least all youhave to do is to drag down the formula from the row above. HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... 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. |
#6
|
|||
|
|||
Thank you for your input Peo. I recall now that I have actually been told
that way of avoiding the numbering going wrong when a row is inserted above the start of the formulas - in fact I am not sure that it was not you that told me the last time. It reminds me of a time when "Big Daddy" Amin chucked all the Asians out of Uganda. One girl came to work in the office of the engineering firm that I was working in at the time - much to the disgust of the woman who ran the office -and she, (the office manager), was often hear to say, "I've told you twice - I won't tell you a second time!" She never did work out why we were all laughing at her. I'll try not to make it a third time<g Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Peo Sjoblom" wrote in message ... You could dodge that as well with =ROW()-ROW($B$2)+1 where B2 represents the cell where you'd put the formula, this will adapt to inserted rows -- Regards, Peo Sjoblom "Sandy Mann" wrote in message ... ...................................... 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. That being the case you would be better with: =ROW()-1 in A2 and copied down. You will still get a hole in the numbers if you insert a new row but now at least all youhave to do is to drag down the formula from the row above. HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Sandy Mann" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up invoice automatic numbering in excel? | Excel Discussion (Misc queries) | |||
Automatic numbering featu | Excel Discussion (Misc queries) | |||
automatic sequential numbering in excel or word | Excel Discussion (Misc queries) | |||
How do I put automatic consecutive numbering on invoices? | Excel Discussion (Misc queries) | |||
automatic numbering | Excel Discussion (Misc queries) |