View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Finding precedents or search the formula

Would you be interested in keyboard shortcuts?

To jump between precendents and dependents,
Select the cell containing the formula, then:
<Ctrl < [

To return to the formula cell, or to start in the dependent cell and jump to
the formula cell:
<Ctrl < ]
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rk0909" wrote in message
...
All,

I am trying to find the precedents to a cell, using a formula (and not
using
the auditing toolbar) can someone help. Also is there a way to search for
the
contents of a formula.

e.g if i have a formula "=sum(c1:c2)". I want a formula with the output as
c1 and c2

thanks much.

Rk0909