In previous article, I mentioned How To Add Months To Date In Google Sheets but in this article, I have mentioned How To Remove Formula In Excel using various possible methods, step by step.
Microsoft Excel is spreadsheet software with many functions, but not everyone knows the operation to remove formulas in the app. You will learn the different methods for doing it in this guide as you read on.
What You Should Know About Removing Formula In Excel
There are a few reasons it is essential to remove formulas in Excel while keeping the cell value. Here are the important reasons:
- It helps speed up your work.
- It lets you display the cell values only without linking them to another cell.
- It helps you to protect the confidential information you may not want to disclose.
Methods For Removing Formula In Excel
There are several options for removing formulas in Excel while retaining the cell values, and you will find the most effective methods here.
Method One: The Paste Special Method
You can remove formulas from Excel using the paste special method as follows:
- Open the Excel sheet that contains the formula you want to remove.
- Click the first cell containing the formula you want to remove.
- Place the cursor at the bottom right corner of the cell you selected, and hold the left click and the mouse to select all other cells containing the formula.
- Press Ctrl + C on your keyboard.
- Right-click the selected cells and click on the Paste Special option.
- Select values from the Paste Special popup and click Ok.
Method Two: The Mouse Trick
- Open the Excel sheet containing the formula you want to remove.
- Select the cells containing these formulas by dragging your cursor over them while holding the left-click button of your mouse.
- Take the cursor to the right edge of the column to display a four-corner arrowed cursor.
- Hold the right-click on your mouse and drag the cursor to the right a little. Then, drag it back to place before releasing the right click.
- Right-click on the column and select Copy here as a value only.
After you complete these actions, you have successfully kept the value and removed the formula.
Method Three: The Paste Values Option
- Open the Excel sheet containing the formula you want to remove.
- Select the cells containing the formulas you want to remove.
- Right-click on the selected cells and select Copy.
- Right-click again and select Paste Values.
- Select Values. The Values option has the paste icon with the number 123 on it.
Method Four: Removing Formula In Excel From the Home Tab
- Open the Excel sheet containing the formula you want to remove.
- Select the cells containing the formula you want to remove.
- Right-click on the cells you selected, then click on Copy.
- Click the Home tab next to the file tab at the top left corner of the spreadsheet.
- Click on the Paste button.
- Select the Values option (the Paste icon with the number 123), under the Paste Values section in the drop-down menu.
Method Five: The Keyboard Shortcut Option
- Open the excel sheet with the formula you want to remove.
- Select the cells that contain these formulas.
- Press Ctrl + C on your keyboard to copy these cells.
- Press ALT + E + S + V + Enter to select the Paste as Values option.
This method is most comfortable if you prefer to use your keyboard, and it removes the formula while retaining the values.
Method Six: Finding And Removing Formula Using Keyboard Shortcuts
The previous methods are suitable if you know which cells contain the formula you want to remove. But you can also find the cells containing the formula, if you don’t know, and remove the formulas with the following steps:
- Open the excel sheet with the formula you want to remove.
- Press Ctrl + G to open a dialog box and click on Special at the bottom left of the box.
- Next, select Formulas and click OK. After this, all cells that contain formulas will get selected.
- Highlight the cells containing the formulas by holding Ctrl and selecting the cells.
- Press Ctrl + C to copy the cells you have highlighted.
- Press ALT + E + S + V + Enter on your keyboard to select the Paste as Values option.
After doing this, the formula will be removed and replaced with values. You can repeat steps 5 and 6 for the other cells that you have highlighted.
Method Seven: Removing Formulas From Multiple Sheets Simultaneously
The methods previously discussed are used for individual sheets, and using any of these methods for one sheet at a time may consume a lot of time. However, you can remove formulas from multiple Excel sheets simultaneously with this method. Follow the steps below to do this:
- Open the first sheet and click on the Name Tab.
- Hold the Shift key and click on the Name Tab of the last sheet to select and group the sheets.
- Go to the first sheet and select all the cells that contain the formula.
- Press Ctrl + C or right-click the cells and select Copy.
- Right-click the cells, go to the Paste option, and select Values.
Since the sheets are in a group, the change you have made in the first sheet will reflect on the other sheets. After you complete these steps, turn off the grouping feature by right-clicking on any of the sheets and clicking on Ungroup.
Conclusion
After reading this article, you will find that removing formulas in Excel is easy. You can use any method that suits you to get the desired result.
You may also like to read:
If Contains Google Sheets Formula (With Examples)
how to export google calendar to google sheets
Export Google Calendar To Excel
How to Add Background Image to Google Calendar Event