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