deleting rows problem (Excel 2000)

Topic

New Reply

my first column consists of consectutive numbers from 1 through 191.

when i delete a row, all numbers in the first column, from that point down get replaced by 3 pound signs (###). how do i avoid this? how can i delete a row and retain consecutive numbering in that first column?

Reply | Quote

Replies

I assume you have a formula which refers to a row that gets deleted and you get a #ref error that does not display since the column is too narrow, hence the ###

1 easy way is to use the Row function.

If the numbers start in row 1, you cna just use
=Row()
and copy this down the column.
and the number will always be the row number.

If (for example) you start in row 5 instead of row 1, just subtract from it:
=row()-4
and copy this down the column
this makes row 5 = 1, row 6 = 2, etc

Steve

Reply | Quote

Thank you, Steve. And thanks for the quick reply.

Russ

Reply | Quote