What is the shortcut key to remove formula in Excel?

Question

Could someone tell me what is the shortcut key to remove the formula in Excel?

Answer 1

Pressing the Delete key is the shortcut way to remove Formula in Excel by selecting the cell that contains the formula. But do note that, by pressing the delete key, you might lose the value also along with the formula. So, if you need to keep the value and just want to delete the formula, then you need to follow the following steps:

1. Select the cell that contains the formula or the range of cells.
2. Then go to the Home tab and from the clipboard group select copy.
3. And after that click paste followed by paste values from the same category group in the Home tab.

If you are keen to become an expert in Microsoft Excel, then check out the Microsoft Excel training course from Intellipaat. And also, watch our YouTube video on MS Excel Shortcut Keys to get started with Excel.