Auto go to link source in Excel 07

[silvi]

There was a function in excel 03 that allowed me
to auto go to linked sources by double clicking. ie if I double click on
Cell A5, I can
automatically go to the linked cell in any other workbook or any other sheet.

I know the "trace precedents" button but I am looking for the double click
function
I will much appreeciate if you have any suggestion
Thanks in advance
Silvi

 

[Shane Devenshire]

Hi,

1. You can press Ctrl+[ (Edit, Go To, Special, Dependents)
or Ctrl+] for Precedents
2. You can display the line trace precedents or dependents lines and then
double-click those lines.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[silvi]

Thanks for the answer.
But I am looking for a "double clicking" method that was able in Excel 03
and I cant find it in Excel 07.
Thanks anyway...
Silvi

Hi,

1. You can press Ctrl+[ (Edit, Go To, Special, Dependents)
or Ctrl+] for Precedents
2. You can display the line trace precedents or dependents lines and then
double-click those lines.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

There was a function in excel 03 that allowed me
to auto go to linked sources by double clicking. ie if I double click on
Cell A5, I can
automatically go to the linked cell in any other workbook or any other
sheet.

I know the "trace precedents" button but I am looking for the double click
function
I will much appreeciate if you have any suggestion
Thanks in advance
Silvi

 

[Ashish Mathur]

Hi,

Office button > Excel options > Advanced, please ensure that the "Allow
editing directly in cell" is unchecked.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[silvi]

Thanks a million!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[Ashish Mathur]

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com