Hi newgal,
You can also use formulas for constants, for that matter.

When I was inserting rows, the clearing of constants was
my original stumbling block, I had found the rest of what I needed.
You can see an example in the first macro at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
The purpose of the macro was to insert rows copying formulas,
the soluton was to insert rows, copying entire rows, then deleting
the constants. The subroutine has several interesting things in it.

That web page also has variations of the macro you were already
given triggered by double-click.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dave Peterson" wrote in message ...
I bet you have constants that you want to keep--row and column headers,
instructions/descriptions for data entry???

If that's the case, select your range to clear and give it a nice name.
(Insert|name|define)

Then whenever you want to clear that range,
just hit Edit|Goto (or F5 or ctrl-g)
select that name (or type it in)
and hit the delete key.



newsgal wrote:

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?

--

Dave Peterson