ExcelBanter - Clear values but keep formulas?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Clear values but keep formulas? (https://www.excelbanter.com/excel-discussion-misc-queries/193192-clear-values-but-keep-formulas.html)

Gumby

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?

FSt1

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?

All times are GMT +1. The time now is 07:19 PM.