How to remove formulas and keep values in excel?

This is heaps easy. First, you pick all the cells that have formulas. Then you copy them. I just use Ctrl+C. Now, right-click on the same cells. You will see an option for 'Paste Special'. A small box will open. In that box, just pick 'Values' and then click OK. Easy as. All the formulas are gone but the numbers are still there. It is a good trick to know.