Thread
:
Delete a formula but leave the data.
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch