Quick selections and moving around
Below you find some short videos on important keyboard shortcuts. This makes your life a lot easier. The videos use a spreadsheet shortcuts.xlsx
Getting to the edge
The shortcuts for Undo and Re-do, and ways to quickly go to the edges of the worksheet.
Quick editing
F2 to edit cells, F4 to insert dollar signs for absolute referencing and and Ctrl-F3 to open the Name manager.
Mac: use Ctrl-U for quick edit and Fn-F4 for the dollar signs… (sorry, this is not so handy as on Windows)
Quick formatting
Quickly format the display of cell contents