hyperlinks

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks

Hyperlinks

resolvedResolved · Low Priority · Version 2003

Douglas has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Hyperlinks

How do I use Hyperlinks and remove Hyperlinks

RE: Hyperlinks

Hi Douglas

Thank you for your question and wlelcome to the forum.

To create a hyperlink:

1. Select the cell which contains the text you wish to put the hyperlink on.

2. Go to Insert - Hyperlink or Ctrl + K.

3. Within the Insert Hyperlink dialogue box, select the appropriate option under Link to on the left hand side of the dialogue box (normally existing file or web page or place in this document). If you are linking to an existing file or web page then you need to have either the web site address or browse to and select the file that you wish to link to.

4. Click OK.

To remove a hyperlink:
1. Right-click on the cell containing the hyperlink.
2. Select Remove Hyperlink.

I hope this helps.
Amanda


 

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.