Friday, May 20, 2011

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!

1 comments:

Roberto said...

it works in excel 2003, but doesn't work in excel 2010
I use italian version

Related Posts Plugin for WordPress, Blogger...