Press F4 again and your formula changes to =100*$B1 (always refer to column B).Press F4 again and your formula changes to =100*B$1 (always refer to row 1).Press F4 and your formula changes to =100*$B$1 (always refer to cell B1).Let’s say you started typing a formula and you typed =100*B1. As you are typing a formula and finish a cell reference, press F4 to toggle between the 4 combinations of reference types. There is a shorthand method for entering the dollar signs as you select or enter cell references in a formula. Absolute Reference: $B$1 tells Excel you always want to refer to cell B1.Mixed Reference: B$1 tells Excel you always want to refer to row 1.Mixed Reference: $A1 tells Excel you always want to refer to column A.Relative Reference: A1 tells Excel to change the cell references to the corresponding columns and rows.There are three different types of references, relative, absolute, and mixed.
