| Home |
| Search |
| Today's Posts |
|
#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. |
| 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
