How to make an exact copy of a formula

Normally, when you copy a formula in Excel, relative cell references automatically change. But sometimes, you want to make an exact copy of a formula, and you don't want the references to change. Watch the short video below to see a few ways you can handle this.