YouTube on MSN

Cell referencing in Excel (when to add a $ in a cell)

Cell Referencing in Excel — where to add the $ sign (using the F4 key) A clear walkthrough of absolute vs. relative cell referencing using the F4 shortcut. The video presents five examples (from easy ...

Does copying Excel formulas cause them to shift? Fixing unit prices with '$'

In Excel, the calculation in the first row is correct, but when I copy it down, the second row becomes 0. Even if I recreate ...