How to use the SELECT ALL PRECEDENTS Keyboard Shortcut in Excel

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.

Discover 242 Excel Keyboard Shortcuts for Windows and Mac

Other useful Select Special keyboard shortcuts

Select Direct Precedents

Select Direct Dependents

Select All Dependents

Select Current Region

Select Current Array

Excel SELECT ALL PRECEDENTS Keyboard Shortcut

Using the Select All Precedents Shortcut