| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear values but keep formulas?
I have created a work sheet where now I would like to delete all the values
but keep all the formulas. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clear values but keep formulas?
hi
try this press F5 to get the goto dialog. click the special button at the botton select contrantsok you have select all non-formula cells. hit the delete key you may get a few #DIV/0! errors Regards FSt1 "Gumby" wrote: I have created a work sheet where now I would like to delete all the values but keep all the formulas. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear contents, keep formulas | Excel Discussion (Misc queries) | |||
| Clear a worksheet without clearing formulas? | Excel Discussion (Misc queries) | |||
| How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
| How do I clear data values wthout losing the formulas? | Excel Worksheet Functions | |||
| How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
Hybrid Mode
