Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    deleting rows problem (Excel 2000)

    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?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: deleting rows problem (Excel 2000)

    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

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    L.A., California, USA
    Posts
    267
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Re: deleting rows problem (Excel 2000)

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

    Russ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •