Exceljet

Quick, clean, and to the point

Select direct precedents

Windows shortcut

Ctrl[

Mac shortcut

⌃[

When you select a formula and use this shortcut, Excel will select cells that are directly referred to in the selected formula. The idea behind the word precedent in this case is "precede" or "before"...cells that come before.

222 Excel Shortcuts for Windows and Mac

Related videos

How to trace formula relationships

In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.

Comments welcome! Read this before posting a question.

I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!! -Annette

Select direct precedents

Related videos

Download 200+ Excel Shortcuts

Excel video training