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

hyperlink

ResolvedVersion 2007

Jay has attended:
Excel Advanced course

Hyperlink

what is hyperlink and why is it used

RE: Hyperlink

Hi Jay

thank you for your questiond and your patience.

Most Office documents allow the creation of hyperlinks. A hyperlink is usually some text or an object (a picture for example) that when clicked re-directis the user.

The idea is the same as following links on a website.

In Excel a hyperlink can take the user to a new file, internet (or intranet) location. It can also take the user to a different tab.

To create a hyperlink in Excel click on the cell that will contain the link or click on the picture that the user will click click and from the Insert ribbon choose Hyperlink. The Dialogue box will let you specify the words the user will see and also the destination - whether it is a tab in the workbook, a web page or a file. Once you OK out of your dialogue box the link is ready to work. You will see that when you hover over the new link the mousepointer changes shape indicating it is a link.

To edit or remove a link right click and choose the appropriate option from the menu.

I hope this helps - let me know if you have any further questions.



Kind regards,
Andrew

Mon 29 Oct 2012: Automatically marked as resolved.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.