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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deteting only formulas 4
Excel Help to copy information from one row at a time to another sheet 1
Clearing cells without clearing formulas 2
Clearing content from a cell (or a group) but retain its formula 2
Remove Data from Empty Cells 5
Clear Cell Fill when leaving Worksheet 2
Need help with macro to copy, paste, and clear cell values 8
How to keep formula and be able to input value in cell? 0

Back
Top