Keep Your Formulas From Shifting In Excel

One of the best features in Excel is the ability to plug in a formula and then easily drag it into new cells and have it automatically shift to the corresponding cell values. But sometimes this can also be the most annoying feature when you don’t actually want the whole formula to shift.

There is actually an easy way to lock in parts of your formula so only the correct parameters change.

Watch below to learn how to use the $US sign to lock in formulas:

Produced by Daniel Goodman

Business Insider Emails & Alerts

Site highlights each day to your inbox.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.