Highlight All Cells Referenced by a Formula

Here's a quick shortcut to highlight all cells referenced by a formula. Go to the cell with the formula then hit

Ctrl-[ (control and open square bracket).

You will see all referenced cells highlighted. To move to the next selection (highlighted cell), simply press enter.

Very useful for auditing worksheets!

TIP: If you want to determine the OPPOSITE of it- that is formulas that reference the current cell  then simply use:

Ctrl-] (control and close square bracket)

Very useful for auditing sheets!

Happy computing!

Tweet