View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dvonj
 
Posts: n/a
Default Using control to clear spreadsheet

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?

I want to use a control (button) to click that will clear the sheet but not
clear the formulas and calulation cells.