Exceljet

Quick, clean, and to the point

Edit the active cell

Windows shortcut 
F2
Mac shortcut 
U

This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell. If you want the cursor to move to the formula bar, see below.

Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point).  "Point" and "Enter" work similarly and allow you to point to a cell. "Edit" mode simply moves the cursor in the formula text. Pressing F2 / Ctrl+U repeatedly will cycle through modes...you'll see the mode displayed in the status bar, in the lower left corner.

On the Mac, this doesn't seem to work in certain areas, notably Define Names, and the New Formatting Rule window when adding a conditional format that uses a formula.

Want to edit directly in the formula bar?

If you want the cursor to move into the formula bar when you use this shortcut, you need to disable the "edit in cell" option (see below):

Excel 2010

File > Options > Advanced > Editing options > Edit Directly In Cell (untick)

Excel 2013

File > Options > Advanced > Editing options > Allow Editing Directly In Cell (untick)

Excel 2011

Preferences > Edit > Double-click Allows Editing Directly In Cell (untick)

Excel 2007

Tools > Options > Advanced > Editing options > Allow Editing Directly In Cell (untick)

Related videos

Tip: 30+ Excel Shortcuts in 12 minutes
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Tip: How to group a pivot table by day of week
In this Exceljet video tip, we show you how to group a pivot table by day of week. We also show you how to calculate a true day name (like Sunday) using a helper table and the VLOOKUP function.
This is the best site I have been to. Direct & to the point. You guys have (almost) everything I need on one site. -Carl
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course