Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work.

Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

Relative cell reference: When copied across multiple cells, the cell formula changes based on the relative position of rows and columns. For example, if you copy the formula =B3*C3 from row 3 to ...