deleting rows

D

Doctorpc631

In microsoft encell 2000 when i delete a row (say row 5) the row disapears
but so does the row number then all other rows are moved up is there a way
to delete the row and keep the number 5?
 
G

Gord Dibben

How are you numbering the rows?

If you just enter 1,2,3,4,5,6,7,8 etc. down column A then you are correct.

The 5 will disappear when you delete row 5.

Better is to enter =ROW() in A1 then copy down Column A.

As you delete rows, these numbers will not change.

Gord Dibben Excel MVP
 
Top