Reading a list won't make them stick. ShortcutFoo has you type each shortcut, then brings it back just before you'd forget it.
Entering Data I
7 shortcuts- ↵Enter and move down
- ⇧↵Enter and move up
- TABEnter and move right
- ⇧TABEnter and move left
- ^↵Enter and stay in same cell
- ^;Insert current date
- ^⇧;Insert current time
Entering Data II
7 shortcuts- ^↵Enter same data in multiple cells
- ^DFill down from cell above
- ^RFill right from cell left
- ^'Copy formula from cell above
- ^⇧'Copy value from cell above
- ⌘KAdd hyperlink
- ⌥DOWNDisplay autocomplete list
Row / Column Operations I
7 shortcuts- ^IInsert rows / columns
- ^-Delete rows / columns
- ^-Delete cells
- ^0Hide columns
- ^9Hide rows
- ^⇧9Unhide rows
- ^⇧0Unhide columns
Row / Column Operations II
5 shortcuts- ⌘⇧KGroup rows or columns
- ⌘⇧JUngroup rows or columns
- ^8Hide or show outline symbols
- ⌘⌥=Zoom in
- ⌘⌥-Zoom out
General I
9 shortcuts- ⌘/Open help
- ⌘ZUndo last action
- ⌘YRedo last action
- ⌘CCopy cells
- ⌘XCut cells
- ⌘VPaste
- ⌘^VPaste special
- ⌘FFind and replace
- ^HFind and replace (replace selected)
General II
9 shortcuts- ⌘GFind next match
- ⌘⇧GFind previous match
- ⌥F1Create embedded chart
- ⌘⇧FToggle autofilter
- ⌥DOWNActivate filter
- ^TInsert table
- ⇧SPACESelect table row
- ^SPACESelect table column
- ⌘ASelect table
Navigation I
6 shortcuts- RIGHTMove one cell right
- LEFTMove one cell left
- UPMove one cell up
- DOWNMove one cell down
- ⌥PAGEDOWNMove one screen right
- ⌥PAGEUPMove one screen left
Navigation II
6 shortcuts- PAGEUPMove one screen up
- PAGEDOWNMove one screen down
- HOMEMove to beginning of row
- ⌘ENDMove to last cell in worksheet
- ^HOMEMove to first cell in worksheet
- ENDTurn end mode on
Selection
7 shortcuts- ⇧SPACESelect entire row
- ^SPACESelect entire column
- ⌘ASelect entire worksheet
- ^⌥RIGHTMove right between non-adjacent selections
- ^⌥LEFTMove left between non-adjacent selections
- ⇧F8Toggle add to selection mode
- ESCCancel selection
Active Cell
7 shortcuts- ⇧BACKSPACESelect active cell only
- ⌘BACKSPACEShow the active cell on worksheet
- ^.Move active cell clockwise in selection
- ↵Move active cell down in selection
- ⇧↵Move active cell up in selection
- TABMove active cell right in a selection
- ⇧TABMove active cell left in a selection
Extend Selection
11 shortcuts- ⇧RIGHTExtend selection one cell right
- ⇧LEFTExtend selection one cell left
- ⇧UPExtend selection one cell up
- ⇧DOWNExtend selection one cell down
- ^⇧LEFTExtend selection to last cell left
- ⇧PAGEUPExtend selection up one screen
- ⇧PAGEDOWNExtend selection down one screen
- ⇧HOMEExtend selection to start of row
- ^⇧HOMEExtend selection to first cell in worksheet
- ^⇧ENDExtend selection to last cell in worksheet
- F8Toggle extend selection mode
Formatting
13 shortcuts- ⌘1Format anything
- ^⇧FDisplay format cells with font tab selected
- ⌘BToggle bold
- ⌘IToggle italic
- ⌘UToggle underscore
- ⌘⇧XToggle strikethrough
- ⌘EAlign center
- ⌘LAlign left
- ⌘RAlign right
- ^⌥TABIndent
- ^⌥⇧TABRemove indent
- ⌘⇧.Increase font size
- ⌘⇧,Decrease font size
Select Special
11 shortcuts- ^GDisplay Go To dialog box
- ^⇧SPACESelect current region around active cell
- ⌘ASelect current region
- ^/Select current array
- ^\Select row differences
- ^⇧\Select column differences
- ^[Select direct precedents
- ^⇧[Select all precedents
- ^]Select direct dependents
- ^⇧]Select all dependents
- ⌥;Select visible cells only
Ribbon
4 shortcuts- ⌘⌥RExpand or collapse ribbon
- TABMove to next ribbon control
- SPACEActivate or open selected ribbon control
- ↵Confirm ribbon control change
Cell Edit Mode
4 shortcuts- ^UEdit the active cell
- ⇧F2Insert or edit comment
- ESCCancel entry
- ^⌥↵Start new line in same cell
Number Formatting
7 shortcuts- ^⇧-Apply general format
- ^⇧4Apply currency format
- ^⇧5Apply percentage format
- ^⇧6Apply scientific format
- ^⇧3Apply date format
- ^⇧2Apply time format
- ^⇧1Apply number format
Borders
4 shortcuts- ⌘⌥0Add border outline
- ⌘⌥DOWNToggle border bottom
- ⌘⌥UPToggle border top
- ⌘⌥⇧-Remove borders
Formulas
7 shortcuts- ⇧F3Open insert function
- ^`Toggle formulas on and off
- ^⇧AInsert function arguments
- ^⇧↵Enter array formula
- F9Evaluate part of a formula
- ^⇧UExpand / collapse formula bar
- ^ADisplay function arguments dialog
Pivot Tables
6 shortcuts- ⌘ASelect entire pivot table
- SPACEToggle pivot table field checkbox
- ⌘⇧KGroup pivot table items
- ⌘⇧JUngroup pivot table items
- ^-Hide pivot table item
- ⌘⌥POpen pivot table wizard