How To Keep Your Formulas Straight 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. Produced by Daniel Goodman and Walter Hickey

Business Insider Emails & Alerts

Site highlights each day to your inbox.

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