excel course - Hyperlinks

The UK's most regular instructor-led training courses.
Training information: excel course · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Hyperlinks

Julian has attended:
Excel Intermediate course

by - delegate Julian [1 post] (2007 Jun 28 Thu, 13:30) Reply

How do I use hyperlinks?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Hyperlinks

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 10:35) Reply

Hi Julian,

Thanks for the question.

Hyperlinks are simply a way of linking from one document to another place. By another place it could be a website, a document or another application. Similar to what you would use in any website.

It depends on what you need to access from your excel spreadsheet, but it can be used as a shortcut by getting from one place to another.

If I can be of any further assistance please let me know

Tracy

· Tips to Facilitate Printing of Excel worksheets
· Benefits of learning about Excel charts
· Microsoft Excel Training: Not Just for Newbies Anymore
· Fun Things I've Done With Excel
· Interesting Lifestyle Applications for Microsoft Excel

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips