Select Special

Select Special

ShortcutWindowsMac
Display ‘Go To’ dialog boxCtrl  G⌃   G
Select cells with commentsCtrl  Shift  OFn  ⌃  ⇧  O
Select current region around active cellCtrl   Shift  *⌃  ⇧  Space
Select current regionCtrlA⌘A
Select current arrayCtrl /⌃/
Select row differencesCtrl\⌃\
Select column differencesCtrlShift|⌃⇧|
Select direct precedentsCtrl[⌃[
Select all precedentsCtrlShift{⌃⇧{
Select direct dependentsCtrl]⌃]
Select all dependentsCtrlShift}⌃⇧}
Select visible cells onlyAlt;⌘⇧Z
 
%d