How do I clear values from cells but not the formula?

[helenks1]

Please bear with me as I am a novice with Excel.
I have a list of names. The row will contain data for each name, some data entered manually and some cells will have formulas that will derive data.
What I want to be able to do is add a new name. I insert a row, copy an existing row, go back to the new row and do "Paste --> Formulas". When I do this, the row fills with all the values from the copied row. What I want is all the cells blank, and those cells that have formulas to retain the formula.

 

[Richard Schollar]

Hi

Select this row and hit the F5 function Key. Hit the Special Button on the dialog window which will open and select the Constants option button and click OK. Then hit the Delete key - this will delete only the hardcoded values.

 

[helenks1]

Thank you Richard, that worked.