Tag: Hyperlinks in Excel

Posted on

Add an email hyperlink to an Excel Worksheet

Hyperlinks can add links to an Outlook email address to your Excel worksheet.  Here is how to do it.

In the cell you wish to add the email address, go to the Insert tab, and select the hyperlink button

hyperlink-button-excel-courses-in-london

Type your preferred text into the cell (this saves space as email address are long).  This will be the text the user will click on to access the email address.

Right-click on this cell and click on Hyperlink. This will open  the Insert Hyperlink dialog box.  Click the E-Mail Address button at the bottom left side.

email-address-excel-training-in-london
Link to the email address from here.

Type the email address into the Address field and click OK.

Now you can add a screen tip by clicking on the screen tip button.

screentip-excel-training-in-London
the screentip button.

Add the text you want to appear in the dialogue box, and then click ok.

hyperlink-and-screentip-excel-training-in-London

Here is the hyperlink in place. The text shows “go”, and the screen tip “Sam’s email” appears when the cursor hovers over the cell.

excel courses in London

Posted on

Using Hyperlinks in an Excel worksheet

I like to have easy access to web pages that link to the data I’m working on.  I can copy and paste the web address into a column, which is fine, but takes up lots of space.

hyperlink-microsoft-excel-2007-intermediate
See, the web address takes up loads of space. Not very helpful.

A colleague showed me a good way to include my hyperlinks, where they are easily accessible within the document, but assigned to a word.

I type “go” and then use the hyperlink function to assign the web address to the word.  I click into the cell containing “go” and then right click to bring up the menu options.  I click on Hyperlink and another small screen appears where I can copy and paste the web address from my browser, or type it in manually.  Then click ok.

hyperlink-apply-microsoft-excel-2007-intermediate
I right click on the cell with “go” and select the Hyperlink option right at the bottom….

When I want to access the website quickly from within the document, I click the word “go” and it takes me to the page I want.  See how little space this needs, in comparison to putting in the whole address.

tidy-hyperlink-microsoft-excel-2007-intermediate
See how little space this now takes up.

When you put your mouse on the hyperlink text, Excel will show you the address as a quick way to preview the information.

hyperlink-preview-microsoft-excel-2007-intermediate
Preview of the web address, if I click on the hyperlinked text.

If you want to change or remove the hyperlink, just right click on the word you’ve assigned and make the changes or remove the link.

Hyperlinks aren’t just for web addresses, I can assign them to another worksheet location, or intranet page, or file.

So for more information on Microsoft Excel 2007 training, why not “go” to https://www.stl-training.co.uk/syl/28/excel-for-power-users.html and boost your Excel skills.