Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Hyperlinks
|
|
|
The UK's most regular Training information: See also: |
|
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.advanced.course - Hyperlinks
Resolved · Low Priority · Version Standard
Reply Fri 26 Oct 2007, 13:02Delegate Katie said...
Katie has attended:
Excel Advanced course
Hyperlinks
Can you put in a hyperlink between different spreadsheets
For upcoming training course dates see: Pricing & availability
RE: Hyperlinks
Hi Katie
Thank you for your question.
You can create a hyperlink to navigate from one sheet to another by doing the following:
1. Select a cell that contains the text or number you wish to operate as a hyperlink.
2. Go to Insert - Hyperlink or you can use the shortcut keys Ctrl + K.
3. On the left side of the Insert Hyperlink window, select Place in this document. The names of each sheet should display in the window to the right.
4. Select the sheet you want the hyperlink to link to, and click OK.
You can also use this method to create a hyperlink to a cell on the same sheet (using the Type the cell reference: box) or to a named range (all named ranges will be displayed in the same box as the sheet names, under Defined Names).
I hope this helps.
Amanda
|