Delete cell contents while retaining formulas

D

Dave A.

I want to delete cell contents from cells I select without deleting the
formulas. How do I accomplish this?

Thanks in advance..
 
F

Frank Kabel

Hi
- select your range
- hit F5, click 'Special' and check 'Constants'
- now hit the DEL key
 
Top