software

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

quot;Vanessa Vquot; wrote:

gt; I have 100 rows of records. I would like to have a column that contains the
gt; record number for each record. However, I don't want to have to type each
gt; record number, from 1 - 100. Is there a way for the numbers to be
gt; 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 quot;CTRLquot; key and drag down the fill handler using the mouse
upto the row (say 100) where your data ends!

-via135
Vanessa V Wrote:
gt; I have 100 rows of records. I would like to have a column that contains
gt; the
gt; record number for each record. However, I don't want to have to type
gt; each
gt; record number, from 1 - 100. Is there a way for the numbers to be
gt; automatically filled in?--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=526991