How to Remove an Automatic Formula in Excel – 5 Methods

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

Remove Automatic Formula in Excel


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

STEPS:

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

Use Paste Values Feature to Remove Automatic Formula in Excel

You will see the values only.

Read More: How to Remove Formulas from Entire Excel Workbook


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

STEPS:

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

Delete Automatic Formula in Excel with Home Tab

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.

Apply Keyboard Shortcuts to Get Rid of Automatic Formula

This is the output.

Read More: How to Remove Formula in Excel and Keep Values


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

STEPS:

  • Go to File Options.

Remove Automatic Formula Through Excel 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.


Download Practice Workbook

Download the workbook.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Aung Shine
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo