OfficeToolTips Excel Tip: Shortcut key to switch between relative ...

You can enter nonrelative references (absolute or mixed) manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 ...

www.officetooltips.com