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