excel.advanced.course - 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