Is there a way to hold down shift/ctrl, etc to make a cell reference an absolute reference when entering a formula instead of having to go back and enter $?
Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...
How-To Geek on MSN
How to use R1C1 referencing style in Microsoft Excel
R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results