Have MSExcel spreadsheet with 1420 rows - want column with row num

B

Brian (Vilkas1

Hi,

I have a MSExcel spradsheet with some 1420 rows. I want to number each of
the rows and have those numbers within the first column. Certainly I do not
want to do this by hand but want some function to do this. How can I do this?

Thanks,
Brian
 
M

mzehr

Hi Brian,
You could try putting in Row(), which would change if you insert or delete
rows, or you could simply use the Edit Fill function, or you could put 1 in
A1, in A2 put =A1+1 and copy down.
 
M

Myrna Larson

Hi, Frank:

Not just a simple copy, though. I did just what you said, and I got 1, 2, 1,
2, 1, 2, .....?

Did you mean to use the fill handle?
 
M

Myrna Larson

In addition to the suggestions re using formulas, you could put the starting
number in A1, then use Edit/Fill/Series to fill the rest of the numbers. Check
it out in Help.
 
Top