Hints and tips home » Excel hints and tips » Editing Formulas in Excel Cells

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

Added by Carlos on 21st September 2006

More Excel hints and tips, like:

• Select Single Data Marker
• Auto-insert the current time
• The dual nature of toolbar buttons