How do I clear a column of data without clearing specific cells?
I have a range of cells where the data is pulled from another spreadsheet,
then subtotaled. Is there a way to "protect" the subtotal formulas so that I
can highlight the entire range, copy and paste values only but not overwrite
the subtotals?
|