How to make a hyperlink in Excel

How to make a hyperlink in Excel

The hyperlink is an element by clicking on which we can move to another area of \u200b\u200bthe document, page or site. The hyperlink in Exel is a very convenient tool especially when working with big documents. After all, it is much easier to click on it and move to several pages and cells forward, than to search for the right one. Distinguish the hyperlink from ordinary text very simple: this is a blue underlined text.



1
How to create a hyperlink?

The hyperlink allows us to move:

  • To a certain place in the current document
  • In a certain place in another document
  • On the web page of the Internet site
  • On the email sending window
  1. We highlight the cell where you need to create a hyperlink.
  2. Click on the right mouse button in the menu by select the "Hyperlink" tab and choose the path.



2
How to create a hyperlink to another document?

We can create a hyperlink to any Microsoft Office document.

  1. In the menu inserts of the hyperlink, select the item to connect to the file, web page.
  2. There find the file to which we will refer to.
  3. We highlight it and click OK.

3
How to create a hyperlink to the site?

  1. In the menu inserts of the hyperlink, select the item to connect to the file, web page.
  2. Then click on the magnifying glass. It will help to bind a link directly to the site that we will open.
  3. After opening the browser, go to the desired site. We open the page, and it will appear in the menu inserts of the hyperlink.

4
How to create a hyperlink to a cell in the current document?

  1. Select the item to tie with the place in the document.
  2. We enter the address of the cell (letter and digit) to which the transition will be performed when pressing the hyperlink.

5
How to create a hyperlink to create a new document?

  1. Choose the item to associate with a new document.
  2. In the column "Name of the new document" we write the name to which the new document will be named.
  3. After pressing the OK button, the new document will be instantly open. If it is not yet needed, in the settings of changes below click "later."

6
How to create a hyperlink by email?

  1. Select the item to associate with email.
  2. In the column "Address" we write on where the letter will be sent, and in the "topic" - the topic of letters.

7
How to change or delete hyperlink?

To change or delete a hyperlink, click on it with right mouse button and select the "Edit" or "Delete" item. When changing the edit menu will appear. And when you click the "Delete" button, the hyperlink will disappear.

The hyperlink in Exel will save time to work with a large number of files or files with a large volume. It will allow one click to move to another part of the document, in another file, site or send an email. This will allow users to make the necessary tasks much faster.

Add a comment

Your e-mail will not be published. Mandatory fields are marked *

close