Auto go to link source in Excel 07
 

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

Auto go to link source in Excel 07
 

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" wrote in message
...
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

Auto go to link source in Excel 07
 

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 :)

"Shane Devenshire" wrote:

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" wrote in message
...
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

Auto go to link source in Excel 07
 

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" wrote in message
...
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

Auto go to link source in Excel 07
 

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


"Ashish Mathur" wrote:

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" wrote in message
...
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

Auto go to link source in Excel 07
 

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"silvi" wrote in message
...
Thanks a million!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


"Ashish Mathur" wrote:

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" wrote in message
...
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