Forum home » Delegate support and help forum » Microsoft Word Training and help » excel word training courses south london - Urgent request please need answer by noon today !
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel word training courses south london - Urgent request please need answer by noon today !
Resolved · Low Priority · Version Standard
Reply Fri 30 Mar 2007, 11:22Delegate Vicky said...
Vicky has attended:
Project Intro Intermediate course
Urgent request please need answer by noon today !
I need to hyperlink from a word document to a worksheet in an excel document. how do I do this so it links to a particular worksheet ?
For upcoming training course dates see: Pricing & availability
RE: Urgent request please need answer by noon today !
Hi Vicky,
To link from your word document to your excel file you would need to use the hyperlink function. Excel will open excel at wherever the last place you saved it was. So if you want to link to Cell A1 in Sheet 5 for example you would have to have saved you excel workbook with the screen showing Sheet 5 and the cursor in A1.
Hope that helps
Tracy
Reply Fri 30 Mar 2007, 13:20Delegate Vicky said...
RE: Urgent request please need answer by noon today !
Thanks Tracy.
What happens though if the spreadsheet is accessed and saved to another worksheet after i have hyperlinked say to cell A1 in sheet 5? will it then open to the next place it was saved?
Vicki
RE: Urgent request please need answer by noon today !
Yes it will open to the active cell where it was saved. A good idea would be to hold the one sheet you need to link into in a separate workbook
Tracy
|