The $ sign in Excel is tiny, but it's why your formulas break when you move them

For some people, broken formulas feel like a normal part of using Excel. Once a formula in their Excel spreadsheet stops working when dragged across a spreadsheet, they just resort to entering formulas row by row instead. That’s such a pain, though, especially since your formulas don't have to break the moment you move them.

Read the full article at the source.