direct link

Hi Friends,

I want shortcut key which will save my time

see i have a worksheet and sheet1 contain all the link formulas which is in sheet2
so when i edit a2 in sheet1 it show me "=Sheet2!A2".

Now i want to know is there any kind of shortcut key that when i edit a2 in sheet1 and press any shortcut key then it will goes to sheet2 A2

Not sure what you mean by a shortcut, but here are a few ideas.
1. You could give sheet2 A2 a name, then the name will appear in the drop-down in the name box (to the left of the formula bar) - select it from the drop-down, and you go there.
2. F5 or Ctrl-G is the Goto shortcut, but you still have to type in where you're going - though again, a name will appear in the list.
3. Do you know about the Formula Auditing toolbar? Switch it on and you'll find there's a 'trace precedents' button. This puts arrows on your workbook, one of which will show a dotted arrow pointing from a little grid. Double-click on the dot at the end of the arrow and it'll open up the Goto window with the formula reference listed as one of the options. There's also a 'remove arrows' button...