Excel 2016 – mixed references
Understanding absolute and relative references in Excel is critical. You can either lock in a cell address in a formula with the F4 key (PC) or CMT T (mac). You can also lock in a row or a column. Video details this:
Leave a Comment
PC Tipster's Blog 