If you've ever had an Excel formula break because you added a few rows of data, you know how frustrating it can be to go back and manually update every cell reference. The # symbol (also called the ...

Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a reference, so it will not change when copying the ...

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work. What am I doing wrong? A: Your partner is right, but ...

Excel formulas are essential for unlocking the full potential of the program. If you're new to Excel and curious about what formulas are and how they work, hereâ s everything you need to know. Excel ...

In October of 2001 , we described in this column how to use the dollar sign ($) to make an Excel formula constant—so when you copy a formula to a different location on a spreadsheet it won’t ...