How to Remove Formulas in Excel (8 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Usually, you can remove formulas from an Excel cell just by pressing the delete button. Unfortunately, this way of deletion removes the values from the cell. Again, you may want to send your spreadsheet to other people and due to confidentiality, you do not want to show the formula in the cells. So, in such situations, you will prefer to erase the formula only. Luckily, there are several ways to remove the formulas in Excel. In this article, we will discuss 8 easy and quick methods on how to remove formulas in Excel. So, go through the entire article to understand the topic properly.
The GIF attached below is an overview image of the article and depicts its main idea.

Overview GIF

Download Practice Workbook

You can download and practice the method we have discussed in the article.

8 Suitable Approaches to Remove Formulas in Excel

For ease of understanding, we are going to use an Item-wise Revenue List of a certain small startup. This dataset includes the Product ID, Selling Price, Cost, and their corresponding Revenue in columns B, C, D, and E respectively.

Dataset of revenue list

Whenever you select a cell in the Revenue column, you can see a subtraction formula in the Formula Bar.

each cell in column E got formula

Note: This is a basic dataset to keep things simple. In a practical scenario, you may encounter a much larger and more complex dataset.
Now, we’ll use this dataset to remove formulas in Excel using several approaches. Let’s explore them one by one.
Not to mention, here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience. Please leave a comment if any part of this article does not work in your version.

1. Using Home Tab Ribbon to Remove Formulas

You can use Excel Ribbon to remove formulas. For example, the Home tab can be used. Here are the steps we followed:

📌 Steps: 

  • Select and copy the cells, where you want to delete formulas.

selecting Column which contains formula and copying them

  • Go to Home > Paste > Paste Values.

Pasting as Values

  • As a result, the formula will be erased, only values remain.

formulas removed, only value remains

2. Utilizing Paste Special Option to Remove Formulas but Keep Values

Another way to remove formulas is to use right-click and Paste Special.
The following steps are involved in this method:

📌 Steps:

  • At first, select the cells and copy them like in Method 1.
  • Right-click on the selected cells, and select Paste Special from the context menu.

selecting paste special option

  • Upon selection, the Paste Special window will show up. Then, select Values. After that, click OK.

working on paste special dialog box

As a result, the formula will be erased from the cells.

Formula is removed from cell E5

3. Applying Keyboard Shortcuts to Delete Formulas in Excel

If you prefer using keyboard shortcuts, you have two combinations of keys to remove formulas from cells. So, here are the examples.
The steps we have followed in this method are:

📌 Steps:

  • Firstly, select and copy the cells using Ctrl+C.
  • Then you can use the following combination.




  • Upon using the keys you will get the values without formulas in Excel.

4. Removing Formulas Implementing Right Key of Mouse

This is an interesting technique to remove formulas in Excel. Besides, it is very easy.
We have used the below steps for this method:

📌 Steps:

  • Select the cells ( E5:E14 range) containing the formula.

selecting column with formulas

  • A four-headed arrow cursor will show up when you select the cells.

four head arrow

  • Hold the right key of the mouse and drag the selection to the right side a little bit. Then, move back the selection to the left. Now, let go of the right key selection, and a context menu will show up. Finally, select Copy Here as Values Only.

selecting Copy Here as Values Only on context menu

Consequently, the formula got erased from the sheet.

Final output of removing formulas in Excel

5. Incorporating Quick Access Toolbar to Erase Formulas in Excel

There are more interesting ways to remove formulas in Excel, such as using the Quick Access Toolbar. Moreover, this method is very quick.
You can use the following steps to try this method:

📌 Steps:

  • Firstly, click on the Customize Quick Access Toolbar icon on the top.
  • Then, select the More Commands option.

customize quick access toolbar icon

  • Add Paste Special from the list of commands, click on the Add button, and tap OK.

adding command in the quick access toolbar

  • Now, Paste Special is added to the Toolbar.

new command added in the QAT

6. Using Go To Dialog Box to Find Cells with Formulas 

There are times when you have several cells, but you do not know which cell contains formulas. In such a scenario, you have to first find out the cells with formulas, and then apply the method to remove formulas.
Here, we have used the following steps:

📌 Steps:

  • Go to the active sheet and type CTRL+G. As a result, the Go To window will show up, select Special.

using keyboard shortcut to bring Go To Dialog box

  • Then, the Go To Special window will pop up, choose Formulas, and press OK.

working on Go To Special dialog box

  • Upon clicking OK, cells containing formulas will be highlighted.

cells containing formulas are higlighted

  • In the end, you have to apply formula-removing methods to these highlighted cells one by one.

7. Applying VBA Code to Eradicate Formulas

Although using formulas is a quick way of editing data, it can be difficult to interpret. Furthermore, if you often need to remove formulas, then you may consider the VBA code below.

📌 Steps:

  • Initially, navigate to the Developer tab and click on Visual Basic in the Code group.

navigating to Developer tab

  • After that, click on Insert >> Module.

inserting a new module

  • At this moment, paste the following code into the module.
Sub Rmv_Formulas()
Dim rng_1 As Range
Dim cell_1 As Range
Set rng_1 = Selection
For Each cell_1 In rng_1
cell_1.Value = cell_1.Value
Next cell_1
End Sub

VBA Code to remove formulas in Excel

  • Next, save the file as a Macro-Enabled workbook.
  • Later, return to the VBA worksheet. Select the range (E5:E14) containing formulas. Again, go to the Developer tab and click on Macros.

clicking on macros option

Suddenly, the Macro dialog box will pop up.

  • Select the only macro available here and click on the Run button.

selecting macro on the Macro dialog box

Magically, the formulas got removed from the selected range of cells.

formulas removed using VBA code

8. Delete Formulas from Multiple Sheets in Excel

Sometimes, you might need to erase formulas from multiple sheets in Excel. Luckily, there are ways to select sheets in groups and apply formula-removing methods. Besides, this method is really time-saving.
We have followed the below steps for this method:

📌 Steps:

  • Firstly, select sheets in a group by pressing the SHIFT key. We have grouped sheets Multiple_1, Multiple_2, and Multiple_3.

selecting multiple sheets at a time

  • Now, go to any of the grouped sheets, and repeat the steps of any previous methods. Easily, formulas will be removed.

formulas removed from multiple sheets

  • After removing the formulas, ungroup the selected sheets by clicking any of the sheets that are not in the group.

Practice Section

For doing practice by yourself we have provided a Practice section like the one below in each sheet on the right side. Please do it by yourself.

practice section


We have discussed most of the easy and effective methods available to remove formulas in Excel. Please feel free to ask any questions you have regarding the above-mentioned methods. Also, you may follow our website, ExcelDemy, to explore more.

Remove Formulas in Excel: Knowledge Hub

<< Go Back to Excel Formulas | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF