eHow launches Android app: Get the best of eHow on the go.

How To

How to Insert Hyperlinks in Microsoft Excel

Contributor
By eHow Contributing Writer
(3 Ratings)

By inserting hyperlinks into Microsoft Excel, you can link documents on your hard drive, web pages and other spreadsheets to your excel document. Hyperlinks are also a great way to cite the source of data. Once you know how to insert hyperlinks, you can link to any file.

Difficulty: Easy
Instructions
  1. Step 1

    Select the cell where you want your hyperlink to be placed. You can either insert a hyperlink into a blank cell or into a cell already filled with information. If the cell is blank, the hyperlink is displayed by its file or Internet location unless you specify different text later. If the cell is already filled, the text will be the link.

  2. Step 2

    Choose "Hyperlink" from the "Insert" menu. A hyperlink wizard pops up.

  3. Step 3

    Note the 4 icons on the left side of the wizard. These icons represent the 4 types of hyperlinks you may insert into Excel. The "Existing File or Web Page" option is probably the one you used most often. Click it and insert the file location of a file on your hard drive or website address. Change the linked text with the form field at the top if you wish.

  4. Step 4

    Pick "E-mail Address" to create a link to an email address. Enter the email address and the subject any email sent via the link should have. When users click on this link, an email to the linked email address opens in their default mail program.

  5. Step 5

    Click "Place in Document" to link to another sheet in the document.

  6. Step 6

    Use the "Create New Document" option to allow the Excel user to open a new Microsoft Office document with a link. The document can be from any Microsoft Office software you've installed.

  7. Step 7

    Hit the "OK" button to insert your hyperlink into your Excel document.

Subscribe

Post a Comment

Post a Comment

Related Ads

  • Have you done this? Click here to let us know.
I Did This
Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.

eHow Computers
eHow_eHow Technology and Electronics