Inserting hyperlinks into a Microsoft Excel spreadsheet is a simple way to quickly access documents, web pages, etc. All you have to do is paste the link, give it a readable label, and then click on it. See below how you can easily insert hyperlinks into your worksheet.
Use the Link Feature
Excel gives you much more than just the ability to store and analyze data – it also offers a handy link tool. You can insert a link to an existing file, a web page, a location within your sheet, or an email address. You can even insert a link to create a new document.
See also: Microsoft plans to kill malware delivery via Excel XLL add-ins
To add a link, go to the desired cell in your spreadsheet, open the Insert , and select “Insert Link” from the Link. If you prefer an alternative method, right-click the cell and go to the “Link” option and press “Insert Link.”
When the Insert Hyperlink box opens, the link options will appear.
Existing File or Web Page: Select a file from the current folder or recent files list, or select a web page from browsing pages, or enter the URL you want in the Address box.
Place in This Document: Select the sheet and enter the cell in the box above or select a defined name.
Create a New Document: Give the document a name, optionally change the path, and choose when to edit the new document.
Email Address: Select an email address you've used recently or enter one near the top. Optionally enter a subject line. You'll only see this option if you save the workbook locally and not automatically to OneDrive.
Text to Display: At the top of the Insert Hyperlink box, you can enter the text you want to use for the link instead of displaying the link itself.
After filling in the fields for the option you chose above, click “OK” to insert the link into the cell.
Tip: You can hover over the hyperlink to see the path.
See also: How to use an advanced filter in Microsoft Excel
Type or paste a URL
If you want to add a hyperlink in Excel for a website or page, you can simply type the URL or paste it into a cell. Once you do this and press Enter or Return, the URL becomes a clickable link. It's a quicker method than using the link tool, and it's especially useful if you don't necessarily want the link to look attractive.
However, there is one setting you will need to enable for it to work. It is a setting that is probably enabled by default, but you can check to make sure it is not disabled. To check the setting, select File > Options and then “Proofing” on the left. On the right, click “AutoCorrect Options”.
In the box that opens, go to the “AutoFormat As You Type” tab. Check the box for “Internet and Network Paths With Hyperlinks” in the top section. Click “OK” to save the change and “OK” again in the Excel Options box.
See also: How to unhide all rows in Excel
Now, you can simply type or paste a link into a cell and press Enter or Return. You should see the URL linked and you can click to visit the website or page.
By using hyperlinks in Microsoft Excel, you can quickly jump to another location, sheet, file, or web page.
Microsoft Excel is an incredibly powerful program with many features that allow users to easily analyze and visualize data in a meaningful way. By using all of Excel's features, such as inserting hyperlinks, you can do even more!
Source: www.howtogeek.com
