How to remove default column formula

Question

How to remove default column formula

852 WCT 0

使用者的影像

When I insert new row to the table, there are some defaul formula in the cells every time.

I don't know why the formula will occurs. How can I remove the defaul column formula?

0 則留言

2 個回答

您的回答

Answer 1

Disclaimer: Due to this thread is posted in Taiwanese locale forum. But because you use English for this post, I will answer according to the language you use. If you need me to answer in Taiwanese, please feel free to let me know, I'll answer in the language you are comfortable with.

Hello 852 WCT,

Thank you for posting on Microsoft Q&A forum

I understand you want to stop Excel from inserting automatic formulas when you add new table rows.

Here is what you can do:

Try turning off automatic formula fill in Excel:
Go to File > Options
Select Proofing
Click AutoCorrect Options…
Go to the AutoFormat As You Type tab
Uncheck the option: “Fill formulas in tables to create calculated columns”

This will stop Excel from auto‑filling formulas in table columns.

Try this then update me on the situation by reply back to this post, I'll be happy to continue assisting you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

852 WCT 0

Thanks for advice. However, problem cannot be solved.

It seems some setting had been saved in this excel file but not the global setting.

Xavier-D 14,550 信譽點數 Microsoft 外部員工仲裁者

2026-01-10T14:58:51.6366667+00:00

Hello,

Thank you for responding

Each time Excel auto‑fills a formula in a table column, do you see a small lightning icon that look like this ⚡? It appears beside the cell.

When Excel auto‑fills it, you should try clicking the icon, it is the AutoCorrect Options button. When clicking it, you see option such as “Stop Automatically Creating Calculated Columns”, select that option.

This option should be able to disable the behavior for that specific table in your Excel.

You should try this then continue update me on the situation.