Number rows consecutively in Excel
 

I am a real dummy when it comes to excel.

I have been trying to figure out how to number my rows consecutively,
however, when I delete a row I need the number to stay consecutive.

I am working a listing of data that is constantly updated and edited.

Number rows consecutively in Excel
 

set the number as =row()

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Babs" wrote in message
...
I am a real dummy when it comes to excel.

I have been trying to figure out how to number my rows consecutively,
however, when I delete a row I need the number to stay consecutive.

I am working a listing of data that is constantly updated and edited.