Microsoft Excel Whiz 2002 2003

Lesson 2: Linking Files

What Is a Hyperlink?

Hyperlink is an object such as graphic or colored underlined text that represents a link to another location in the same file or in a different file. It can usually be seen in a Web page and when you click it, it will lead you to another web page. Hyperlinks are one of the key elements of HTML (Hypertext Mark-up Language) documents. You can create hyperlinks in workbooks/worksheets by using either texts or graphics that link to charts, another workbook/worksheet, web pages or other files.

Inserting Hyperlinks

The easiest way to create a hyperlink is to type it in a cell. If you enter an e-mail address mjs@hotmail.com or a website (http://www.bluemountain.com) on your worksheet, it will automatically be formatted as a hyperlink.

To create Hyperlinks follow these steps:

  1. Select the cell or text where you want to insert a hyperlink.

  2. Do one of the following:

    • Click Insert Hyperlink button on the Standard toolbar.

    • Press Ctrl+K.

    • Click the Insert menu and choose Hyperlink.

    • Right-click and choose Hyperlink

      When the Hyperlink Screen Tip dialog box appears, type the text that you want to appear when you hover over the hyperlink with the mouse pointer.

      If you do not specify a Screen Tip, the path of the linked-to-file becomes the Screen Tip.

  3. In the Address box, type the file or web page you want to link to your worksheet.

    If you do not know the path of the file you want to link, search in the Look in drop-down list box or make use of the Place Holders to search for a particular file, web page, e-mail address or you can even create a new document to be link on your worksheet.

  4. Click OK.

    The hyperlink appears in your worksheet as underlined colored text. To go to the linked file, point to the hyperlink text and when the mouse pointer changes into a hand, click it.

To edit hyperlink text, follow these steps:

  1. Select the hyperlink text.

  2. Do any of the following:

    • Click Insert, then choose Hyperlink.

    • Press Ctrl+K.

    • Click the Insert Hyperlink button on the Standard toolbar.

    • Right–click and then choose Edit Hyperlink.

The Edit Hyperlink dialog box appears.

You can now make necessary changes on your hyperlink.

Remove Hyperlinks

To remove the hyperlink, do any of the following:

Whiz Words

Hyperlink

HTML

Ctrl + K

Lesson Summary

A Hyperlink is a link that points to a file, a specific location in a file, or a Web Page on the internet or intranet.

To Insert a Hyperlink: Select the cell you want to use for the hyperlink and click the Insert Hyperlink button from the Standard toolbar or use other methods in displaying the Hyperlink dialog box. Select or type the file or Web address for the hyperlink's destination and click OK.

To Edit Hyperlink: Select the hyperlink text or object, and use any of the ways in displaying the Edit Hyperlink dialog box. Make the changes you want and click OK.

To Remove Hyperlink: Select the hyperlink text or object. From the Edit Hyperlink dialog box, click the Remove Hyperlink button and then click OK or right-click over the hyperlink and then click Remove Hyperlink.

Study Help

Directions: Answer the following.

  1. What is a Hyperlink?

  2. What does HTML mean?

  3. How do you remove a hyperlink?

  4. What is the shortcut key for displaying the Hyperlink dialog box?

  5. How can you edit a hyperlink?

Activity 1

Directions: Follow the instructions carefully.

  1. Open a New Workbook.

  2. On cell A1 type Hyperlink Texts.

  3. On cell A3, type your e-mail address.

  4. On cell A4, type a sample of Web address.

  5. On cell A5, type the Information.

  6. Insert a hyperlink on cell A5 that will lead to the file Information.xls.

  7. On cell A6, type the text My Favorite Songs.

  8. Insert a hyperlink on cell A6 that will lead to the file My Favorite Songs.htm.

  9. Save the workbook as Hyperlinks on the Excel-Activities folder.

  10. Open the file Sales Report.xls.

  11. Copy its content to Sheet 2 of Hyperlinks.xls.

  12. Select the range A4:G21. Move it to A5:G22.

  13. Copy the data as shown in Sample 1 to A3:D23 of Sheet 3.

  14. Add Another field named Total Sales.

  15. Get the data in Sheet 2 to compute for the Total sales. Use 3-D cell references in the formula.

  16. At cell A1, type Date.

  17. In cell B1, enter the formula the will display the current date including the time.

  18. Save your work.

  19. Select Sheet 1 and Sheet 3.

  20. Print it.

Related

Категории