Hyperlinks automate work in Microsoft Excel by adding the possibility to move in just one click to a website, document, or working file.It does not matter whether the user is the document on a computer or a page on the Internet.
What is a hyperlink?
Hyperlink - a reference to the document by clicking on which opens the online page, file or folder (depending on which is indicated by reference).
There are several ways to add a hyperlink in Excel:
1. Using the worksheet objects such as charts, shapes, WordArt, and others.
2. By using the "Hyperlink".
3. Directly into the cell.
Create a hyperlink
The easiest way to add hyperlinks - directly into the cell.To do this, select the desired cell, click on the right mouse button and in the list that appears, select "Hyperlink".A similar effect can be done through the menu by pressing the "Insert" - "Hyperlink" or "Insert" - "Link" - "Hyperlink" (depending on the version MSExcel).
You can also attach a hyperlink to any worksheet objects: pictures, not
es, charts, figures and objects WordArt.To create a hyperlink, you must select the correct object, the context menu and select "Hyperlink".You can add hyperlink via the menu bar (as well as adding links to the cell).
There is one caveat - set in such a way hyperlink to chart fail.To do this, select the chart and press the key combination Ctrl + K.This shortcut also works on all other objects Excel.
Another way - it is adding a reference to the function.It is written in such a way: "= HYPERLINK (address, [name])."
In the "e" indicates the location of a cell or range of cells.You can also specify the address of a file stored on your computer or on the same web page.In the "Name" field enter the text that will be displayed in a cell with a hyperlink.The text will be written in blue and underlined.
For example, if you write a formula in the cell = HYPERLINK (Sheet1! A1; "Amount"), then on the sheet it will look like a normal word "Sum" in the cell.When you click on a word, a hyperlink Position the cursor on cell A1 sheet 1.
to go to the site, you need to slightly modify the formula: = HYPERLINK («http://abc.ru»; «Back to the site abc.ru»).In this case, the text will be written "Go to the site abc.ru», clicking on which will open this site in your browser.
To change a hyperlink, you need to click on a cell, right-click and select "Edit Hyperlink".Similarly, you can remove the link by selecting the context menu "Remove Hyperlink".