Delete a formula but leave the data.

Discussion in 'Excel Beginners' started by trvlnmny@yahoo.com, 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
    1. Advertisements

  2. Claus Busch Guest

    Hi,

    Am Mon, 28 Apr 2014 14:36:33 -0700 (PDT) schrieb :

    > 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.


    to avoid the #ref error write in A1:
    =ROW()
    and copy down.

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


    Regards
    Claus B.
    --
    Vista Ultimate / Windows7
    Office 2007 Ultimate / 2010 Professional
     
    Claus Busch, Apr 29, 2014
    #2
    1. Advertisements

  3. Guest

    On Monday, April 28, 2014 5:36:33 PM UTC-4, wrote:
    > 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.


    Claus,
    Thank you, that did it.
     
    , Apr 29, 2014
    #3
    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.