how do i clear data in excel and not lose the formula
G Gord Dibben Jun 30, 2006 #2 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
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
