Tuesday, May 28, 2013

How to Insert Hyperlinks in Microsoft Excel


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

Blogger news