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

[Guest]

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

 

[Guest]

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.

 

[Frank Kabel]

Hi
- in A1 enter 1 and in A2 enter 2
- select both cells and copy them down

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian ([email protected])" <Brian
([email protected])@discussions.microsoft.com> schrieb im Newsbeitrag
news:[email protected]...

 

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

 

[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.

 

[Frank Kabel]

Hi Myrna

yes I meant the fill handle