View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Deleting the DATA but NOT the Formulae!

Press F5
Click on Special
Check the Constants option
Click Ok
Press Delete

"Big Gray Cat" wrote:

Folks ---
I have a spreadsheet that got -- to understate the matter, delicately -- the
wrong
data pasted into it. I need to delete JUST the numbers, but leave the
recalculation
logic in place. How does one do this?

Thankx in advance from the Big Gray Cat.