Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.
You can utilize a Hyperlink in a worksheet cell to have quick access to related information in another file, web page or a different location within your document.
In our example to the right, we have collected data for the years 2014-2018. In the additional worksheets within our documents, we have more in depth information for each year.
We want to establish a hyperlink for each year in this data, so we can click on it to take us to the corresponding worksheet with additional data for that year.
Let’s get started by clicking on cell F2. Go to the Insert tab and locate the Links section. Click on the Hyperlink button and the Insert Hyperlink dialog box will appear (as shown in the image below).
As you can see in the Link to section, you are able to link to an Existing File or Web Page, Place in This Document, Create New Document and E-mail Address. We want to link to a Place in This Document so we will click on that button and select 2014 from the list of documents. Select OK when finished.
The hyperlinks are now visible in row two of our table (as shown in the image above). When we click on the 2014 hyperlink, it will take us to our document titled 2014.
This concludes the Links tutorial.
Click next to continue to the Excel 2010 Text tutorial.