How to Remove Formulas in Excel: 7 Easy Ways

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 easy and quick ones.


Download the Workbook

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


7 Suitable Approaches to Remove Formulas in Excel

1. Remove the Formulas by Using Home Tab

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.

Remove the Formulas by Using Home Tab

  • Go to Home > Paste > Paste Values.

Remove the Formulas by Using Home Tab

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


2. Remove the Formula but Keep the Data Using Paste Special

Another way to remove formulas is to use right-click and Paste Special.

Following steps are involved in this method:

šŸ“Œ Steps:

  • At first, select the cells and copy.

Remove the Formula but Keep th Data Using Paste Special

  • Right-click the selected cells, and Paste Special.

Remove the Formula but Keep the Data Using Paste Special

  • Upon selection, the Paste Special window will show up. Then, select Values. As a result, the formula will be erased from the cells.


3. Use of 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.

Alt+E+S+V+Enter

or

Ctrl+Alt+V, V, Enter

  • Upon using the keys you will get the values without formula.

Similar Readings:


4. Remove the Formulas Using the 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 containing the formula.

Remove the Formulas Using the Right Key of Mouse

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

Remove the Formulas Using the Right Key of Mouse

  • 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 window will show up. Finally, select Copy Here as Values Only, and formulas will be erased.


5. Use Quick Access Toolbar to Erase the 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, go to the Quick Access Toolbar.

Use Quick Access Toolbar to Erase the Formulas in Excel

  • Customize the Quick Access Toolbar and select MoreĀ Commands.

Use Quick Access Toolbar to Erase the Formulas in Excel

  • Add Paste Special from the list of commands and click OK.

Use Quick Access Toolbar to Erase the Formulas in Excel

  • Now, Paste Special is added to the Toolbar. Finally, select and copy the cells, then apply Paste Special from the Toolbar.


6. Find Cells with Formulas in Excel and RemoveĀ 

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 formula removing methods.

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.

Find Cells with Formulas in Excel and RemoveĀ 

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

Find Cells with Formulas in Excel and RemoveĀ 

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

Find Cells with Formulas in Excel and RemoveĀ 

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


7. 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. I have grouped sheets Multiple1, Multiple2, Multiple3.

Delete Formulas from Multiple Sheets in Excel

  • Now, go to any of the grouped sheets, select and copy the cells where you want to erase formulas.

Delete Formulas from Multiple Sheets in Excel

  • Then, apply any of the formula removing methods, such as Paste Special, to the copied cells. It will remove formulas from all the grouped sheets.

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

Conclusion

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.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo