excel.advanced.course - hyperlinks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Hyperlinks

excel.advanced.course - Hyperlinks

resolvedResolved · Low Priority · Version Standard

Katie has attended:
Excel Advanced course

Hyperlinks

Can you put in a hyperlink between different spreadsheets

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


Server loaded in 0.08 secs.