how can i erase a table in excel without it actually deleting the formula?

Question

i have a table with data
i would like to clear the data in the table without actually deleting the formulas in some of the cells do you know what i mean?

or instead i would like to "Lock" or disable the cells containing the formulas
so when i clear the table everything in the table is erased except the formulas in the specified cells

thank you 10 points for the best answer

Answer 1

You can protect portions of the worksheet and leave other parts unprotected. This will allow some cells to be cleared while the others are "open".

Answer 2

Step through each of the cells if it starts with the = sign then the contents are a formula if they have numerical values they will be inputted they can be cleared. I would suggest that any cells cleared be made a different colour so you know which to populate in future

Answer 3

The values will be returned to zero (or blank for text) when you delete the data in the data cells. Select the columns that hold values (not formulas) and hit the Delete button.

Try it first, without saving, and you'll see that it works.