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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Lee Jeffery

    Loop to compare and delete or leave

    Lee Jeffery, Jul 25, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    118
    Lee Jeffery
    Jul 28, 2004
  2. g wills
    Replies:
    4
    Views:
    135
    JulieD
    Dec 3, 2004
  3. Alok Garg

    Leave Management System

    Alok Garg, Jan 10, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    90
  4. ojchippy

    Clear contents but leave formulas in Excel

    ojchippy, Apr 23, 2006, in forum: Excel Beginners
    Replies:
    10
    Views:
    198
    David McRitchie
    Jun 16, 2006
  5. paic101

    Remove the Formula but leave the value alone?

    paic101, Jul 8, 2007, in forum: Excel Beginners
    Replies:
    2
    Views:
    98
    paic101
    Jul 8, 2007
  6. Hans F.
    Replies:
    4
    Views:
    96
    Sandy Mann
    Aug 10, 2007
  7. Lofred

    Delete cell value but keep formula in cell.

    Lofred, Dec 31, 2009, in forum: Excel Beginners
    Replies:
    7
    Views:
    280
    JLatham
    Jan 2, 2010
  8. Mike
    Replies:
    4
    Views:
    185
    Claus Busch
    Jan 5, 2014
Loading...