Share via

Remove A Formula In A Table

Anonymous
2010-10-25T12:07:14+00:00

I had a table with column C being the total of column A & B but now I don't want the formula to be inserted automatically everytime I insert a new record to the same. How to do so?

Thanx in advance friends!

Best Regards, Faraz A Qureshi

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-10-25T13:20:02+00:00

    It was a collection of columns that I had Formatted as a Table in the groups Style on the Home Tab. On the same in first few records I needed the sum of ColA & ColB in ColC but afterwards like other formula consisting columns ColC remains to present the formula in every new row and I have to manually change/delete the same.

    Best Regards, Faraz A Qureshi

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-10-25T12:16:28+00:00

    Hi,

    check if you don't have a VBA code, press Alt + F11 and check that you don't have a code there, if you have delete it

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-10-25T12:11:42+00:00

    Hi,

    I don't understand this, perhaps you could post a sample of the data, the formula in column C and what you expect to see when youinsert a new record.

    If this post answers your question, please mark it as the Answer.

    Mike H

    Was this answer helpful?

    0 comments