How to Remove an Automatic Formula in Excel – 5 Methods

The sample dataset represents Total marks obtained using the SUM function.

Method 1 – Using theÂ  Paste Values Feature to Remove an Automatic Formula in Excel

The Paste Values feature returns the cell values only, and ignores formatting and formulas.

STEPS:

• Select D5:D8 (containing formulas).
• Press Ctrl+C to copy.
• Right-click and select Paste Values inÂ Paste Options.

• You will see the values only.

Method 2 – Delete an Automatic Formula in Excel in the Home Tab

STEPS:

• Select D5:D8 (containing formulas).
• Select Home âž¤ Paste âž¤ Paste values âž¤ Values.

• Youâ€™ll see the values without the formulas.

Method 3 – Using Keyboard Shortcuts to remove an Automatic Formula

STEPS:

• Select D5:D8 and copy it.
• Press â€˜Altâ€™, â€˜Eâ€™, and â€˜Sâ€™ one after another.
• In the Paste Special dialog box, select Values.
• Click OK.

This is the output.

Method 4 – Remove an Automatic Formula Through the Excel File Options

STEPS:

• Go to File âž¤ Options.

• In the Excel Options dialog box, in Formulas, uncheck Formula AutoComplete.
• Click OK.

This is the output.

Method 5 – Use the Formulas Tab to Delete an Automatic Formula in Excel

STEPS:

• Select Formulas.
• Choose Manual in Calculation Options.

This is the output.

Related Articles

<< Go Back to Remove Formulas in Excel | Excel FormulasÂ | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine

Aung Shine completed his bachelorâ€™s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF