excel navigation

• [ctrl] + [home] / [end] = first (top-left) and last (bottom-right) data field
• [ctrl] + [<arrows>]
• [Control] + [PgDn[] / [PgUp] = next / previous sheet

excel shortcuts

• [F9] = recalculate / refresh
• [shift] + [enter] = bottom right of selection (after paste)
• [alt] + [down] = open drop-down (combobox) for data validation fields
• [Control] + [shift] + [1] = format cell
• [Shift]/[ctrl] + [Space] = select or highlight row/column
• [ctrl] + [g] > special... = goto special, select formulas
• [Control] + [;] <space> [Control] + [:] = insert current date & time
• [ctrl] + [-] = insert row, does not always work on international keyboards (azerty)
• [alt] + [i] [r] = older compatibility shortcut to insert row
• [alt] + [e] [d] = older compatibility shortcut to delete row (after selection)

More space to work & show/hide

• [Control] + [F1] = hide/unhide ribbon
• [Control] + [Shift] + [U] = small/big formulla bar
• [Control] + [6] = show/hide objects
• [Control] + [8] = toggle the outline symbols between showing and hiding [collapse] [grouping] [bar]
• [Control] + [9] = Hide the selected rows.
• [Control] + [0] = Hide the selected columns.

formula edit

• [F4] = Toggle absolute / relative reference
• [alt] + [=] = auto sum

does not always work or dubious...

• select + alt + ; = copy without hidden rows
• [F9] (or formula ribbon audit "evaluate formula") = step-by-step evaluation
• [Control] + [-] or [+] (when fully selected) = insert or delete row/col
• use formula tips to select section = select formula sections
• ctrl + [ = follow link?

Some laptops (Dell) without a Pause/Break key have a replacement for that: Fn + B, so:

• Fn + B = Pause (pause execution);
• Ctrl + Fn + B = Break (break execution);

Other wierd ones

• [Control] + [5] = strikethrough
• [Control] + [4|u] = underline
• [Control] + [3|i] = italic
• [Control] + [2|n] = bold
• [Control] + [1] = format cell dialogue