microsoft excel courses in london

microsoft excel courses in london - Excel

Resolved · Low Priority · Version Standard

Excel

Lisa has attended:
Excel Intermediate course
Excel Introduction course

by - delegate Lisa [2 posts] (2007 Dec 19 Wed, 16:18) Reply

How do i set up a hyperlink to another spreadsheet

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel

by - trainer Amanda diamond contributer [1243 posts] (2007 Dec 20 Thu, 10:14) Reply

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