How to Add Links in Excel

Microsoft Excel is a fully functional spreadsheet application that allows users to organize, store and analyze many different types of data. You can add links to websites, to other documents, or even to other cells and pages in the same spreadsheet when you need to refer to another source for additional information, backup, and support for your data. Friend.

Insert a link to a location in the spreadsheet

How to Add Links in Excel Picture 1

Select the cell where you want to create the link. You can create a shortcut link in any cell in the spreadsheet.

How to Add Links in Excel Picture 2

Click the "Insert" tab, then tap "Hyperlink." The link creation window will appear.

How to Add Links in Excel Picture 3

Click the "Place in This Document" option in the left menu. With it, you can link to every cell in the spreadsheet.

How to Add Links in Excel Picture 4

Enter the cell you want to link to. You can do this by:

To type a cell location, select the page that contains the cell from the "Cell Reference" list. You can then enter a specific cell, such as "C23", in the "Type the cell reference" field.

Or you can select from the cell or range defined in the "Defined Names" list. When you select them, you won't be able to type in the location yourself.

How to Add Links in Excel Picture 5

Change the title (optional). By default, the title of the link will simply be the name of the cell you're linking to. You can change it by typing whatever you want in the "Text to display" field.

You can click the "ScreenTip" button to change what appears when a user hovers over a link.

Insert link to website

How to Add Links in Excel Picture 6

Copy the address of the page you want to link to. You can link to any page simply by copying its address. This address can be copied from the address bar on the web browser. To copy an address from a link on a website, right-click the link and select "Copy address" or something similar, depending on your browser.

How to Add Links in Excel Picture 7

Select the cell in the Excel spreadsheet into which you want to insert the link. You can insert into any cell in that spreadsheet.

How to Add Links in Excel Picture 8

Click the "Insert" tab and press the "Hyperlink" button. A window allowing you to insert many different types of links will appear.

How to Add Links in Excel Picture 9

Select "Existing File or Web Page" on the left side of the window. The file browser will be displayed.

If you are using Excel 2011, select "Web Page".

How to Add Links in Excel Picture 10

Paste the website link into the "Address" field at the bottom of the window.

If you're using Excel 2011, paste the link into the "Link to" field at the top of the window.

How to Add Links in Excel Picture 11

Change the title of the link (optional). By default, the link will display the full address. You can change it to whatever content you like, such as "Company website". Click the "Text to display" field and enter the text you want to use as the link's title.

With Excel 2011, that will be the "Display" field.

Click the "ScreenTip" button to change the content that appears when the user hovers the mouse cursor over the link.

How to Add Links in Excel Picture 12

Click "OK" to create the link. Your link will appear in the cell you previously selected. You can try it out by clicking on it or edit it by holding down the link and then clicking the "Hyperlink" button again.

Insert link to send email

How to Add Links in Excel Picture 13

Click the cell where you want to insert the link. You can insert a link to send an email into any cell on the spreadsheet. Click any cell to select it.

How to Add Links in Excel Picture 14

Click the "Insert" tab. The items that you can insert into the spreadsheet are displayed.

How to Add Links in Excel Picture 15

Click the "Hyperlink" button. A window allowing you to insert different types of links will appear.

How to Add Links in Excel Picture 16

Enter the email address you want to link to in the "E-mail address" field. The "Text to display" field will be automatically filled in when you add an address. "mailto:" will be automatically added to the beginning of the address.

If you've entered addresses before, you can now select them from the list at the bottom of the window.

How to Add Links in Excel Picture 17

Enter a pre-made subject in the "Subject" field – optional. You can leave the link as default if you want, or set a pre-made theme to make it more convenient for users.

How to Add Links in Excel Picture 18

Change the title to be displayed (optional). By default, the link will display "mailto: address@example.com " but you can change it to anything you want, such as "Contact us". Click the "Text to display" field and change it to whatever you want.

Click the "ScreenTip" button to change the content that appears when the user hovers over the link.

How to Add Links in Excel Picture 19

Click "OK" to insert your link. A new email link will be created and when you click on it, your website or mail client will appear with a new message sent to the email address you entered.

Insert a link to somewhere on your computer or server

How to Add Links in Excel Picture 20

Highlight the cell where you want to insert a link. You can insert a link to a document or location on your computer or server into any cell in the spreadsheet.

How to Add Links in Excel Picture 21

Click the "Insert" tab and click "Hyperlink". A window allowing creating links in the spreadsheet will appear.

How to Add Links in Excel Picture 22

Select "Existing file or webpage" from the left menu. This option allows you to link to any location or document on your computer (or server).

With Excel 2011 for OS X, tap "Document" and then select "Select" to browse files on your computer.

How to Add Links in Excel Picture 23

Use your browser to select a folder or file to link to. The fastest way to link to a specific file or folder is to use a file browser to navigate to the desired file/folder. You can link a folder to open it on click, or select a specific file to open with a link.

You can switch between display methods to see nearby open files and change the folder you're viewing.

How to Add Links in Excel Picture 24

Type or paste the address for the file or folder. You can enter the address for a file or folder instead of navigating to it using a browser. This is especially useful for content that resides on another server.

To find the actual address of a local file or folder, open an Explorer window and navigate to that folder. Click on the folder path at the top of the Explorer window to make the address appear: now just copy and paste the address.

To link to a location on the server, paste the address for that folder or location that readers can access.

How to Add Links in Excel Picture 25

Change the displayed title (optional). By default, links will display the full address to the linked file or folder. You can change this in the "Text to display" field.

How to Add Links in Excel Picture 26

Click "OK" to create the link. The link will appear in the cell you selected. When you click that box, the file/folder you specified will be opened.

Your spreadsheet users need to have access to the linked file from the file location used in your link. In cases where you plan to send a document to other users, embedding the file may be more useful than adding a link to it.