How to copy expressions without changing cell references in Excel Your email has been sent Image: AndreyPopov, Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...
How-To Geek on MSN
Don't underestimate the power of the $ sign in Excel formulas
Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.
Another example: If you have cells named SubTotal and Tax, and type a formula =subtotal*tax Excel converts that to =SubTotal*Tax automatically. Because of this and because Excel puts functions in all ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results