Excel Shortcuts

Select an entire row with shift+space, a column with ctrl+space.
Insert the current date with ctrl+; and the current time with ctrl+shift+;.
Get the sum of a group of cells by selecting all the cells, then hitting alt and +.
Hide the row you currently have highlighted with ctrl+9, and the current column with ctrl+0. (That’s a zero.)
To make a line break within one cell, hit alt+enter.
To see all the formulae in your spreadsheet, inside their cells, hit ctrl+`. (That’s the accent grave key, aka the tilde key, in the top left.)

Variants Example

- Trim All (.:.) - A1.:.E10 trims blanks from both ends.
- Trim Trailing (:.) - A1:.E10 trims only trailing blanks.
- Trim Leading (.:) - A1.:E10 trims only leading blanks.