Jumping to a reference cell

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

When I am standing in a cell depending on another cell -
is there a "quick/smart" (eg. a F1..F12 button) way to
jump to reference cell without having to retrieve the
trace precendents arrows...and double click on them...
 
Stephen,

If it is a single cell area reference on another sheet, or a multi-cell area
reference on the same sheet, then use

Ctrl-[

Ctrl-] will do the reverse.

HTH,
Bernie
MS Excel MVP
 
Back
Top