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:
- Select and copy the cells, where you want to delete formulas.
- Go to Home > Paste > Paste Values.
- 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:
- At first, select the cells and copy.
- Right-click the selected cells, and 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:
- Firstly, Select and copy the cells using Ctrl+C.
- Then you can use the following combination.
Ctrl+Alt+V, V, Enter
- Upon using the keys you will get the values without formula.
- How to Remove Subtotals in Excel (2 Easy Tricks)
- Remove Numbers from a Cell in Excel (7 Effective Ways)
- How to Remove Password from Excel (3 Simple Ways)
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:
- Select the cells containing the formula.
- A four-headed arrow cursor will show up when you select the cells.
- 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:
- Firstly, go to the Quick Access Toolbar.
- Customize the Quick Access Toolbar and select More Commands.
- Add Paste Special from the list of commands and click OK.
- 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:
- Go to the active sheet and type Ctrl+G. As a result, the Go To window will show up, select Special.
- Then, Go To Special window will pop up, choose Formulas, and press OK.
- Upon clicking OK, cells containing formulas will be highlighted.
- 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:
- Firstly, select sheets in a group by pressing the Shift key. I have grouped sheets Multiple1, Multiple2, Multiple3.
- Now, go to any of the grouped sheets, select and copy the cells where you want to erase formulas.
- 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.
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.