Delete a formula but leave the data.
 

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.

Delete a formula but leave the data.
 

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

Delete a formula but leave the data.
 

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.

Paste Special!
 

Hello! To delete the formula (and not the values), you can simply just highlight the row/column/array, then right click-copy (or ctrl + c), then right click again then paste special - then go to paste values. Voila! no more formulas. Hope this actually helps!

PS. you can check this site out for more excel help.