View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EllenSwarts
 
Posts: n/a
Default 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?