A spreadsheet is an interactive canvas for logging data and using formulas. The cells of a spreadsheet can hold a variety of things including hyperlinks. Let's look at two types of links in Excel that we can add to a spreadsheet.
How to Add Links in Excel to Spreadsheets Quickly
Note: Watch this short tutorial screencast or follow these quick steps that compliment this video:
1. Click on an Excel Cell to Add a Link to It
First of all, let's make sure that we've clicked in a cell so that we can add something to it.
2. Go to Insert and Apply the HyperLink Option
Now, let's go to the Insert tab on the ribbon and click on it. Next, I'll find the Hyperlink option and click on it. The menu that pops up allows us to add links. On the left side, I'll make sure that I've selected the Existing File or Web Page option.
3. Insert a Link in Excel to a Website URL
In the Address box, I'll type in a URL to a website to link to in my spreadsheet. I'll also add some text if I want a different preview to show than the URL itself.
Then I'll click OK, now that we've got the hyperlink in the spreadsheet. I'll click on it and the link will open in a browser.
4. Add a Link in Excel to a Sheet
I'll go ahead and switch back to my spreadsheet and next we'll add a hyperlink to a different tab in the workbook. You can use the same option, but this time we'll choose the Place in This Document option and choose another sheet name. Clicking on that new hyperlink will now take me to another sheet.
You can quickly add links in Excel to offsite web pages, internally to sheets in your workbook, or to documents or resources elsewhere.
More Excel Tutorials on Envato Tuts+
Dive into our series: How to Make and Use Excel Formulas (Beginner Bootcamp). Also, find more Excel tutorials on Envato Tuts+ to help you learn how to work with formulas and data better in your spreadhsheets. Here are a few quick video tutorials to work through:
- How to Use the Excel Format Painter in 60 SecondsAndrew Childress27 Feb 2017
- How to Insert an Excel File into PowerPoint in 60 SecondsAndrew Childress06 Feb 2017
- How to Use AutoSum in Excel in 60 SecondsAndrew Childress17 Mar 2017
Remember: Every Microsoft Excel tool you learn, and workflow you master, the better spreadsheets you'll make.