View Single Post
  #1   Report Post  
EllenSwarts
 
Posts: n/a
Default Protecting formulas

How do I clear a column of data only without erasing the formulas?
Similarly, I have several sections of subtotals, where the data being
subtotaled is formula driven. Can I protect the subtotal formulas so that I
can paste special values only without pasting over the subtotals?