Results 1 to 13 of 13

20030804, 19:41 #1
 Join Date
 Apr 2001
 Posts
 304
 Thanks
 0
 Thanked 0 Times in 0 Posts
Automatic sequential row numbering (Excel 2000)
Is it possible to automatically number cells in a spreadsheet, like you can/would autonumber paragraphs in a Word document?

20030804, 20:04 #2
 Join Date
 Aug 2003
 Posts
 5
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000)
Yes, easily done a couple of ways but one I use the most to number columns is as follows:
In cell A1 enter: 1
in cell A2 enter: =A1+1
then select cell A2 and the rest of the cells below it that you want to number and use fill down command.
This method can be used to fill in numbers starting in any row or column...and you can start with any number you want and use any formula. (For example, if you only want to use even numbers for some reason, then in my example you would enter a 2 in A1 and enter: =A1+2 in cell A2.)

20030804, 20:52 #3
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Automatic sequential row numbering (Excel 2000)
Nothing builtin to do what you want, you could create a macro do be triggered on some event, though we would need more details on what you need.
Steve

20030805, 10:42 #4
 Join Date
 Jul 2002
 Location
 London, United Kingdom
 Posts
 192
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000)
Hello Satiria
This is my understanding of the question, when someone enters information in a column, then the cell next to it will automatically add numbers.
If this is the case, I have added a spreadsheet that I refer back to in order to accomplish it. If any other Loungers know a simpler and cleaner formula, I would be glad to have it.
Regards and Hope this helps

20030805, 11:34 #5
 Join Date
 Apr 2001
 Posts
 304
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000)
Actually  I found something fairly easy. I thought that if you the Extend List Formats and Formulas turned on under Tools  Options  Edit tab that if I typed a "1" in cell A1, then clicked and dragged the fill handle down and copied to cells A2A100 that it would automatically fill in numbers 2100, but instead it just copies the "1" value. Did a little research and the solution is much simpler than macros, etc. If you type a "1" in cell A1, a "2" in cell A2, a "3" in cell A3  highlight / select them all, THEN click the fill handle and drag down through cell A100 it will fill in the cells sequentially. For the Extend List Formats and Formulas option to work, "formats and formulas must appear in at least three of the five rows preceding the new row" according to Microsoft. Thanks for all the help, though.

20030805, 11:44 #6
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Automatic sequential row numbering (Excel 2000)
It is enough to fill and select 2 cells, then use the fill grip. Excel will increase the values by the difference of the first two.
If you fill more than 2 cells, Excel will create a linear extrapolation  see what happens if you enter 1 in A1, 2 in A2 and 3.3 in A3, select A1:A3 and then fill down.

20030805, 17:43 #7
 Join Date
 Dec 2000
 Location
 NJ, USA
 Posts
 239
 Thanks
 2
 Thanked 1 Time in 1 Post
Re: Automatic sequential row numbering (Excel 2000)
Another way would be to put the formula
=ROW()
in column A. The formula automatically returns the row number, and would adjust even if rows are subsequently added (which may or may not be what you want...)

20030805, 19:21 #8
 Join Date
 Apr 2001
 Posts
 304
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000)
Actually, no that doesn't work as Row 1 is a "Title" row, and Rows 2100 are actual info. So if you were attempting to number information, and the actual information didn't start until Row 2, in theory the numbering would start with 2...instead of 1. Of course I'm speaking totally theoretically  I didn't actually try it (shame on me!!!)

20030805, 19:32 #9
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Automatic sequential row numbering (Excel 2000)
In that case , you could (totally theoretically) use =ROW()1

20030806, 15:07 #10
 Join Date
 Nov 2001
 Posts
 6
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000)
I would use the following formula in cells A2 and below:
=IF(B2="","",MAX(A$1:A1)+1)
This allows one to skip rows if necessary.

20030806, 15:15 #11
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Automatic sequential row numbering (Excel 2000)
Good tip, thanks!

20040209, 16:25 #12
 Join Date
 Jan 2001
 Location
 Cincinnati, Ohio, USA
 Posts
 7,089
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Automatic sequential row numbering (Excel 2000
Is there a link to the Microsoft article that I assume this refers to? The term "fill handle" to me indicates the paint bucket for highlighting cells, which is obviously not what is needed here.
(Just in case you were wondering I am attempting to accomplish the same thing!)Mark

20040209, 16:43 #13
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Automatic sequential row numbering (Excel 2000
The "fill handle" is the bottom right corner of a range. When you put the mouse over it it changes to a small "+". At this stage you can double click and it will fill to the bottom of the data.
Steve