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