how do i clear data in excel and not lose the formula

  • Thread starter Thread starter Guest
  • Start date Start date
F5>Special>Constants.

Check or uncheck which constants you don't want selected, like maybe Text which
is used for titles.

OK your way out and Edit>Clear Contents.


Gord Dibben MS Excel MVP
 
Back
Top