Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete a formula but leave the data.
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Numbers in Column, Leave Formulas in Column Intact | New Users to Excel | |||
Filters - I want to delete single addresses and leave all the dupl | Excel Programming | |||
delete some cell formulas and leave others using code | Excel Worksheet Functions | |||
Excel should allow delete cell's value but leave formula alone. | Excel Discussion (Misc queries) | |||
Delete rows with numeric values, leave rows with text | Excel Programming |