Delete cell contents while retaining formulas

  • Thread starter Thread starter Dave A.
  • Start date Start date
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..
 
Hi
- select your range
- hit F5, click 'Special' and check 'Constants'
- now hit the DEL key
 
Back
Top