Editing Formulas

• F2 edits the active cell

• F3 inserts a named range

• F4 cycles thru absolute/relative/mixed reference type in a formula

• Esc stops editing and will undo changes

• Cell references in the formula automatically highlighted in different colors

• When you insert new rows or columns the formulas are adjusted automatically to include them!