How to Insert Hyperlinks in Microsoft Excel

Step-by-Step Guide

1. 1

   Step 1: Right-click the cell you want to place the hyperlink in.

   The cell may be empty or contain text or a graphic image.
   
   Right-clicking the cell displays a popup menu.
2. 2

   Step 2: Select "Hyperlink" from the popup menu.

   This displays the Insert Hyperlink dialog box.
   
   If the cell where your hyperlink will be placed was empty and you want to display a text hyperlink, enter it in the "Text to display:" field. ,, Type the name for the file to be created in the "Name of new document" field. , The file location will be displayed under "Full path:"; if this location is where you want the file to be created in, do nothing.
   
   If you want the file to be placed in a different location, click "Change" and browse for a new location in the Create New Document dialog box.
   
   Click "OK" once you have selected the desired location to close the dialog. , Choose one of the options under "When to edit:"
   
   If you want to display a ScreenTip when you rest your mouse cursor on the hyperlink, click "ScreenTip�" and enter the text in the "ScreenTip text:" field of the Set Hyperlink ScreenTip dialog box, then click "OK."
3. 3

   Step 3: Select "Create New Document" from the "Link to:" options in the left pane.

4. 4

   Step 4: Give the file a name.

5. 5

   Step 5: Decide whether to accept the location displayed for your new file to be placed in or change it.

6. 6

   Step 6: Decide whether you want to edit the new document now or later.

7. 7

   Step 7: Assign a screen tip to the hyperlink if desired.

Detailed Guide

About the Author