It appears as though a certain column in my table has established a default formula that I can't seem to reset. When I add a new row to the table, the cell in that column always puts this default formula. How do I change this default?

Similar to other questions: Excel table inserting old formula in new rows. How can I reset to the new formula? Excel: set default formula for each cell in column How to change underlying formula for Excel Table?


When you change the formula in that cell, you will get an auto-correct prompt that will let you choose to update the Calculated Column formula.

  • I do not want to reset it to the calculated column formula, I want to remove the column formula (and understand why it gets set). Thanks! – BobtheMagicMoose Oct 8 '18 at 18:58
  • 1
    quickest way to remove the formula is to convert to a range, then convert back to table – nutsch Oct 9 '18 at 0:25
  • That's what I've read - shoot, I was hoping there was some way to avoid that :D – BobtheMagicMoose Oct 9 '18 at 11:51
  • You can also decompress the excel file and remove it there but it's hardly easier – nutsch Oct 9 '18 at 14:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.