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
|