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.