Rows and Columns

V

Vanessa V

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?
 
T

Toppers

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
 
V

via135

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
 
Top