excel xp training - Hyperlinks

Resolved · Low Priority · Version Standard

Hyperlinks

Dominique has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Dominique [3 posts] (2007 Sep 20 Thu, 16:33) Reply

how do i create hyperlinks?

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 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
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	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: hyperlinks

by - trainer Katie gold contributer [214 posts] (2007 Sep 25 Tue, 15:45) Reply

Hi Dominique,

Thank you for your question.

You can set hyperlink on:
1) Cell or
2) Data or
3) Pictures / drawings

To set up hyperlink:
1) Select the object you want to link
2) CTRL+k
3) Set destination
a) Type in web address; or
b) Select part in your workbook; or
c) Select a file on your computer; or
d) Set up an email address with email subject
4) ScreenTip: type in message on yellow smart-tag
5) Press OK

Hope this helps.

Katie

· How to check for and reduce errors in Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Two
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Training Budgets In A Bad Economy
· Compare Different MS Excel Training Methods

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Rate this page: