98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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 ! | Word forum
excel word training courses south london - Urgent request please need answer by noon today ! | Word forum
Resolved · Low Priority · Version Standard
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 ?
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
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
Training information:
- Excel word training courses south london
- Microsoft word training courses london
- Microsoft word training
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. |
Word tip:Multiple Cut and Pastes in MS WordIf you need to cut and paste more than one selection into a document, you don't need to Cut & Paste repeatedly, just use the built in SPIKE feature. |