MS Office is the software which has so many applications. Every application has different functions. In every application of Microsoft Office there are so many things which you can perform. So, in this blog we discuss about how to add hyperlinks, bookmarks and mailto links in MS Excel. MS Office makes the work of every firm easier. You can install via www.office.com/setup.
A hyperlink gives you the way to open the web page by selecting a cell in the worksheet. By using this, you can easily access to other Excel workbooks.
Bookmark creates a link to the specific area in the current worksheet or to the different worksheet in the Excel file.
Mailto links is the link in email address. Hyperlinks and Bookmarks make it easier to navigate between areas of related data. Mailto links makes it easier to send an email message to an individual or organization.
Add Hyperlink to the Web page and to Excel file:
Add Hyperlink to Web Page:
For this, first open the Insert Hyperlink dialog box, and then select the Existing File or Web page tab. Now in the address line, type a full URL address. And select ok to complete the hyperlink and close the dialog box.
Add Hyperlink to a Excel file:
First of all, open the insert Hyperlink dialog box and select the existing file or Web page tab. After this, select the Browse for file to open the link to file dialog box. Then find the file name and select the file and select ok. The file will be added to the address line in the Insert Hyperlink dialog box. Now select OK to complete the hyperlink and close the dialog box.
How to create the Bookmark to the same Worksheet:
First of all, type the name in the cell which will act as a anchor text for the bookmark and press Enter. After this select the cell to make it a active cell. Then open the Insert Hyperlink dialog box. Now select the place in this document tab. In the Type the cell reference box, you have to enter a cell reference to a different location on the same worksheet. At the end, select OK to complete the bookmark and close the dialog box.
How to insert the Mailto link into an Excel File?
First of all type a name in a cell which will act as the anchor text for the mailto link and press Enter. After this, select that cell to make it active cell. Now you have to open the Insert Hyperlink dialog box. Then select the E-mail Address tab. Now in the Email address field, enter the email address of the person who will receive the email. Under the Subject line, enter the subject of the email. At the end, select OK to complete the mailto link and close the dialog box.
If you still have any doubts, then you can contact to the customer care of MS Office via Office.com/setup . Or you can also call on the toll free number for help and support.