If you’ve ever copied a formula in Excel or Google Sheets only to get the wrong results, you’ve run into the difference between relative and absolute references. The secret to fixing this? The humble $ sign. By locking rows, columns, or both, the $ symbol ensures your formulas always point to the right cell—whether you’re calculating taxes, building a multiplication table, or converting currencies.