I have 100 rows of records. I would like to have a column that contains the
record number for each record. However, I don't want to have to type each
record number, from 1 - 100. Is there a way for the numbers to be
automatically filled in?

If you simple want numbers 1 to 100, then type 1 in row 1, 2 in row 2, select
both cells and copy down to row 100. Excel will increment each cell by 1.

HTH

"Vanessa V" wrote:

I have 100 rows of records. I would like to have a column that contains the
record number for each record. However, I don't want to have to type each
record number, from 1 - 100. Is there a way for the numbers to be
automatically filled in?

hi!

Enter 1 in the first cell in the column in which you want the
record number and then select that cell.

Hold the "CTRL" key and drag down the fill handler using the mouse
upto the row (say 100) where your data ends!

-via135



Vanessa V Wrote:
I have 100 rows of records. I would like to have a column that contains
the
record number for each record. However, I don't want to have to type
each
record number, from 1 - 100. Is there a way for the numbers to be
automatically filled in?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526991