Select Special

ShortcutWindowsMac
Display 'Go To' dialog box Ctrl G G
Select cells with comments Ctrl Shift O Fn O
Select current region around active cell Ctrl Shift * Space
Select current region Ctrl A A
Select current array Ctrl / /
Select row differences Ctrl \ \
Select column differences Ctrl Shift | |
Select direct precedents Ctrl [ [
Select all precedents Ctrl Shift { {
Select direct dependents Ctrl ] ]
Select all dependents Ctrl Shift } }
Select visible cells only Alt ; Z