Spreadsheet Design & Auditing Tips

Pressing F4 (as soon as the cell reference is entered in a formula) cycles through the relative, absolute, and mixed cell references. Use the fill handle to copy formulas to adjacent cells. Enter a formula using mixed cell references, then use the fill handle to copy the formula. ................
................