copying true formulas only

  • Thread starter Thread starter sheywood
  • Start date Start date
S

sheywood

I want to create a new row and copy selectively from the one above. I
want to copy formats and formulas but not values. I am using Excel
2002. I can use insert to create a new row with all the same formats
(including conditional formatting). If I then use
paste-->special-->formulas Excel pastes both formulas AND values of the
cells which contain no formula. I want to avoid writing something which
tests each cell to see if it contains a true formula. Any suggestions
anyone?
 
Sheywood,

After you do your paste and the cells are still selected, use Edit | Go To..., Special, and select Constants, then hit OK, and then
Delete. That will clear any non-formulas from your pasted region.

HTH,
Bernie
Excel MVP
 
Back
Top