I need to delete the values in some cells,

  • Thread starter Thread starter Skip
  • Start date Start date
S

Skip

but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help
 
Skip said:
but I want to leave the formulas in the cells intact. Can this be
done?
Thanks for any help
Click to expand...

Maybe this is what you want. Select the entire range of cells.

Edit / Go To / Special... / Constants / OK / Delete

If not, provide more details.
 
Maybe this is what you want.  Select the entire range of cells.

Edit / Go To / Special... / Constants / OK /Delete

If not, provide more details.
Click to expand...

Glenn< I tried your idea, no luck.
I got a no cell selected box.
Skip
 
Back
Top