| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Word form to Excel source file | Excel Discussion (Misc queries) | |||
| ?? Auto go to link source | Excel Worksheet Functions | |||
| Can Excel auto-direct you to the source of a link? | Excel Discussion (Misc queries) | |||
| Can I get excel to auto direct me to the source of a link? | Excel Worksheet Functions | |||
| How do I break a link to a source when opening Excel 2000? | Excel Worksheet Functions | |||
Linear Mode
