Microsoft Excel create a mixed reference - F4 key to change references by Chris Menard. Chris Menard demonstrates how to use Excel's mixed reference in this short 90 second video. You can either type the dollar symbol or use the F4 function key to cycle through the references. An Absolute Reference looks like this $B$4. Both the column and row are frozen.
A Mixed Reference looks like either $B4 or B$4. The first mixed will freeze column B since the dollar sign is in before the column. The latter will freeze row 4 since the dollar sign in before the row.
Chris Menard does Microsoft training in metro Atlanta.
Tags: Microsoft Excel create a mixed reference - F4 key to change references by Chris Menard, Mizuno, Excel, Mixed Reference, Master Instructor, Chris Menard, Excel Training, Instructor-led, Absolute, Reference, trainer, training, atlanta