In Excel, pressing F4 in the formula bar or cell adds the dollar sign ($) to create absolute references (e.g., A1 becomes $A$1). This locks the cell reference so it doesn't change when copied. F2 is for editing, Ctrl+F4 closes the workbook, and Ctrl+F3 opens the Name Manager.