Can you clear values and leave formula

  • Thread starter Thread starter Roger Dodger
  • Start date Start date
R

Roger Dodger

Is there a way that I can clear the info/data without removing the formula?

Thanks
Kevin
 
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.
 
Back
Top