microsoft excel courses in london - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Excel

microsoft excel courses in london - Excel

resolvedResolved · Low Priority · Version Standard

Lisa has attended:
Excel Intermediate course
Excel Introduction course

Excel

How do i set up a hyperlink to another spreadsheet

RE: Excel

Hi Lisa

Thank you for your question.

You can create a hyperlink to another spreadsheet by doing the following:

1. Select the text that you want to make into the hyperlink.
2. Go to Insert - Hyperlink or use Ctrl + K.
3. Check that the 'Existing file or web page' option is selected on the left hand side (under Link to:)
4. Use the Look in window to select the folder where the file you wish to link to is located
5. Select the file you wish to link to; then click OK.

Test the hyperlink - if you click on it, the file it is linked to should open.

I hope this helps; and that you enjoy your next course in January.

Happy Christmas
Amanda


Server loaded in 0.1 secs.