View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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