R Roger Dodger Sep 19, 2010 #1 Is there a way that I can clear the info/data without removing the formula? Thanks Kevin
D Dave Peterson Sep 19, 2010 #2 Select the range to clear -- include any formulas you want, but don't include any cells with data you want to keep (like headers, instructions, ...). Then hit F5 Then click the Special button Select constants Click ok Hit the delete key on the your keyboard. Then the cells in the original selection that were constants will be cleared, but the cells with formulas will be untouched.
Select the range to clear -- include any formulas you want, but don't include any cells with data you want to keep (like headers, instructions, ...). Then hit F5 Then click the Special button Select constants Click ok Hit the delete key on the your keyboard. Then the cells in the original selection that were constants will be cleared, but the cells with formulas will be untouched.
