Excel SELECT ALL PRECEDENTS Keyboard Shortcut

Using the Select All Precedents Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut selects all cells that are directly or indirectly referred to in a selected formula. You must first select a formula before using this shortcut.
Other useful Select Special keyboard shortcuts