Analytical functions become painless when using Microsoft Excel. This tool has the most versatile features to perform different calculations. Excel lets you use formulas to complete the task as smoothly as you want to. Some formulas are built-in and sometimes you may have to create Excel formulas. However, the main thing is that your results must be stable.
Remember that removing formulas in Excel needs you to have some basic understanding of Excel and its formulas. If you keep on changing the values of any cell you will not get the same results, obviously. And sometimes it is not required and detrimental.
Whether you have small or large data, Excel helps you in any case without producing issues. Removing formulas in Excel without losing your data is just a click away.
Here we have come up with some methods to remove formulas in Excel without losing your original data.
- Remove the formula using Paste Special
- Remove the formula using Mouse Trick
- Remove the formula using Paste Values
- Remove the formula using the Home Tab
- Remove the formula using Keyboard Shortcuts
Remove Formula Using Paste Special Method
Let’s start with our first method to remove formulas in Excel:
- Go to the Excel sheet from which you want to remove the formula.
- Choose the cells that contain formulas you need to remove. Copy all of them.
- Right-click and choose the Special Paste option.
- Choose the option Value from the box Paste Special and press OK.
- You can see the formula is not there because it has been removed from the cell and your data is secured.
Remove Formula Using Mouse Trick
Using the Mouse trick, you will get to know the process of removing formulas in Excel. Just follow the steps carefully:
- Go to the Excel sheet that has formulas to be removed.
- Now, choose the cells that have formulas you need to remove.
- Put the mouse cursor on the right edge of the column.
- Press and hold the right key of the mouse, drag the cursor to the right side and bring it back to the cell.
- Right-click on the mouse and choose “Copy here as a value only.”
- The option “Copy here as a value only” will keep the value and remove the formula.
Remove Formula Using Paste Values
Using the Paste Values method, we can remove the formula easily in Excel:
- Go to the Excel sheet that has formulas to be removed.
- Choose all the cells that contain formulas to be removed.
- Right-click and choose Copy option to copy all the selected cells.
- Now, right-click once again and choose the Paste Options and then the Values option.
- You can see all the data remained as it is and the formulas are removed.
Remove Formula Using the Home Tab
Similar to the above methods, this Home tab method holds the same level of significance. To use this method, you have to follow the steps given below:
- Go to the Excel sheet that contains the formulas to be removed.
- Select all the cells with formulas.
- Choose the option Copy once you have selected all the cells by right click on them.
- Open the Home Tab and choose the downward arrow given under the Paste option.
- Now, click on the Paste Values option.
- You will see all the formulas are gone except the values you have added to the sheet.
Remove Formula Using Keyboard Shortcut
This method is convenient for those who don’t want to indulge in lengthy procedures and want some shortcuts. Follow the steps given below:
- Go to the Excel sheet from which you need to remove the formula.
- Choose the cells that contain formulas to be removed.
- Press CTRL + C to copy all the selected cells having formulas.
- Now, press ALT + E + S + V + Enter all at once to select the Paste as Values option.
Final Thoughts
In this post, you get to know different methods used for removing formulas in Excel without losing the original data. Keeping data safe while removing some values is the main thing and that’s what you have learned in this article. Continue sharing the knowledge and keep exploring Excel!
