How to Insert Hyperlinks in Microsoft Excel

By eHow Computers Editor

Rate: (0 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.

Instructions

Difficulty: Easy

Step1
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.
Step2
Choose "Hyperlink" from the "Insert" menu. A hyperlink wizard pops up.
Step3
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.
Step4
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.
Step5
Click "Place in Document" to link to another sheet in the document.
Step6
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.
Step7
Hit the "OK" button to insert your hyperlink into your Excel document.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Insert Hyperlinks in Microsoft Excel

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads