Edit the Active Cell

Using the Edit the Active Cell Shortcut

Windows keyboard shortcut

Mac keyboard shortcut

This Excel shortcut enters cell edit mode with the cursor at the end of the last line of text.

Once you have entered Cell Edit Mode you can cycle through other edit modes, such as edit, enter, and point, by continuing to press F2 (Windows) or CTRL + U (Mac).

If you want to edit directly in the formula bar when using this shortcut follow these steps:

Excel 2013

File > Options > Advanced > Editing Options > Allow Editing Directly in Cell (de-select)
Other useful Cell Edit Mode keyboard shortcuts