View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default

Newsgal, edit, go to, special, constants, OK, delete, or how about saving
the file as a template and open a new copy each , month?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"newsgal" wrote in message
...
Excel:
Is there any way to clear all cell entries EXCEPT formulas so that a
spreadsheet that needs to have new entries every month can be cleared
easily
for the new month without having to work around the formulas when clearing
the cells?