Delete a formula but leave the data.

Discussion in 'Excel Beginners' started by, Apr 28, 2014.

  1. Guest

    I am using Excel 2003.
    I have a spreadsheet with a column of sequential numbers.
    They were created by putting the #1 in A1 and then the formula =A1+1 in all the other cells in that column.
    I now have a need to remove some of the rows but I want the remaining rows to keep sequence number that was first assigned.
    When I delete a row column A of the successive rows get an Aref error.
    I think what I need to do is remove the formula after the numbers have been created.
    Is this something that can be done?
    Thanks for any and all help.
    , Apr 28, 2014
    1. Advertisements

  2. Claus Busch Guest


    Am Mon, 28 Apr 2014 14:36:33 -0700 (PDT) schrieb :
    to avoid the #ref error write in A1:
    and copy down.

    If you want to delete the formula copy your data => Paste => Paste
    special => Values

    Claus B.
    Claus Busch, Apr 29, 2014
    1. Advertisements

  3. Guest

    Thank you, that did it.
    , Apr 29, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.