Thread: How do I clear contents from a spreadsheet but not the formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How do I clear contents from a spreadsheet but not the formulas
Edit--Goto--Special--Constants

Hit delete.

Of course try this with a backup copy to make sure it's deleting only what
you think it should be!

Dave
--
Brevity is the soul of wit.


"Roberto" wrote:

I want to use my 2006 spreadsheet in 2007 using the same formulas, but
different data. How do I erase last years data "en mass", but leave the
formulas in place.
Reply With QuoteReply With Quote