200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Select all precedents – Microsoft Excel shortcut

Making use of a formula in your spreadsheet? Select any of your active formulas and this shortcut will select all cells directly or indirectly referenced by that formula. This selection includes those from the prior shortcut, but also those that indirectly affect the data you are using.

Ctrl Shift {

Control Shift {

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.