deleting rows

  • Thread starter Thread starter Doctorpc631
  • Start date Start date
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?
 
The row number shouldn't disappear unless you are hiding the row, not
deleting it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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
 
Back
Top