Select All Precedents

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