Entering Data

Shortcut	To
F2	Edit the current cell entry (cursor moves to the end of the cell contents)
Ctrl+Enter	If an empty range is selected, this enters the value/formula in all cells
Alt+Enter	Within a cell entry, start a new line (carriage return)
Tab	Move to the next column. If a worksheet is protected, moves to the next unprotected cell.
F9 (within a cell)	Highlight all or part of a formula within a cell + F9. Returns the value of the formula.
Ctrl+Z / Ctrl+Y	Undo / Redo last action
F4	In the formula bar, anchors a cell, row, or col ($A$1). Can toggle to diff combinations.