How to add two links or hyperlinks to an Excel cell
Before each innovation of companies specializing in the development of computer programs, new needs arise from users, which forces them to continue to constantly innovate , to make updates to correct errors and to implement new functionalities. Among them is the innovative way to add two links to one cell in Excel.
Let's talk about office automation
In the universality of programs on which all the computers in the world can count, without a doubt, office automation programs have become a fundamental pillar, an element that can not just not miss a computer .
The most important programs in this field for many years have been those developed by Microsoft, which are part of the Microsoft Office suite .
However, it is indisputable that the most relevant programs in this package are Microsoft Word and Microsoft Excel. The world's most widely used word processor and spreadsheet.
The importance of Excel
While initially these programs can maintain an interface that at first glance may appear to be very basic, the reality is different. It is not for nothing that many organizations have dedicated themselves to teaching courses at different levels to teach people how to use these programs, in especially Microsoft Excel.
This spreadsheet has a wide variety of functions and tools which are just amazing. Excel is a program that has been designed for preparation of different types of documents that go far beyond numbers, formulas and charts. Everything within the reach of a spreadsheet .
Therefore, if you are just starting to educate yourself about the features and tools that this wonderful software retains, this article will surely be important for you.
The hyperlink
Of the items that can be part of any worksheet you create through Microsoft Excel, hyperlink is one of them.
What are they for? Simple hypertext links serve as reference for another document , a web platform, an e-mail address, among others. Inserting a hyperlink in Excel is the easiest way to reference a location.
The type of hyperlink can vary depending on your needs or where you want to direct the person reading your article, document or spreadsheet, it can direct the user to another item that is in the directory. 'a computer or, as we have said, to web platforms . It will all depend on what you need.
Add hyperlink to an Excel cell
Inserting a hyperlink in Excel is a very simple task. In case you need to enter the address of a page Web, you will just need to follow a series of simple instructions, which will be presented below:
- Select the cell to which you want to add the hyperlink.
- Click on the "Insert" tab.
- Click the option "Hyperlink".
- Add the web address you want to direct the user to to view your spreadsheet.
- Click on "Accept"
Ready! Thanks to these instructions, the hyperlink will have been successfully added in the cell Excel, from so that when you click on it, the browser of your choice will open upon entering the page you specified.
But I need two! What do I do?
Now there are people who need to add more than one hyperlink. The ideal solution would be for these to be added in different cells. But the needs of the spreadsheet you are building may require that two or more links are contained in the same cell .
Is there a solution for this type of case? Unfortunately, this is a very difficult mission to accomplish, as the hyperlink takes up the entire cell. So, no matter how many addresses you enter, the cell will direct you to a single address.
Final alternative
While it doesn't work as a hyperlink as such, if you must have two email or webpage addresses in one cell, you can use option to insert text box . By adjusting the height and width of the cell , you can copy two addresses in text format. This is one of the alternative methods to add two links to an Excel cell.
