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?
|