Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/01/Remove-formula-but-keep-data-in-Excel.xlsx

In this video I demonstrate four methods to remove formulas from cells but retain the results of those formula.

The methods are:
1) Ribbon command or right-click menu
2) Shortcut key
3) Drag and drop values
4) Quick Access Toolbar button including ALT shortcut key.

This video will answer the following queries:
What is the Excel paste values shortcut?
In Excel how do I paste values only?
How do I remove formula but keep data in Excel?
How do I display values instead of formulas in Excel?
------------------------