Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

Keep Your Formulas From Shifting In Excel

Daniel Goodman,Walter HickeyAug 3, 2013, 00:38 IST

Your browser doesn't support HTML5 video.

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 $ sign to lock in formulas:

kalturavideoplaceholder

Produced by Daniel Goodman