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

NOW WATCH: Tech Insider videos

Want to read a more in-depth view on the trends influencing Australian business and the global economy? BI / Research is designed to help executives and industry leaders understand the major challenges and opportunities for industry, technology, strategy and the economy in the future. Sign up for free at