| Be My Friend

Hyperlink in Excel

Hyperlink | Insert Hyperlink | Webpage or File | This Document | Hyperlink Shortcut | Remove Hyperlink

If you click on a particular hyperlink, which brings you to the reference sheet, file, or webpage.

In other words, if you click on an image or text, which is assigned with a hyperlink, it jumps to a given section or sheet. The hyperlink itself can be text or a picture.

Use Insert link dialog box to create hyperlinks in Excel.

Web Page or File

To create a hyperlink to a web page or file, execute the following steps.

1. Select a cell where you want to create a hyperlink.

2. Rightclick on that cell and click on the hyperlink.

Create Hyperlink in Excel

2.1. You can also select the hyperlink option from Excel Ribbon.

2.2. Go to Insert Tab, click on links group, and click on Link.

Click Link

3. You will get a dialog box with three options (Web Page or File, This Document, Email Address).

Hyperlink Options

4. To create a hyperlink to an existing file click on the web page or file.

5. Choose the folder and select the file you want to link.

Existing File

6. Now that cell text color changed to blue. which means hyperlink applied to that cell text. if somebody clicks on that cell it opens the selected file.

Open File

This Document

To create a hyperlink to a place in this document, follow the below steps.

1. Select a cell where you want to create a hyperlink.

2. Open hyperlink dialog box using the above discussed option.

3. Select This Document option and choose cell reference or defined names to give hyperlink and click Ok.

This Document

4. Now that cell text color changed to blue. which means hyperlink applied to that cell text. if somebody clicks on that cell it jumps to Book2.

Cell Reference

For Windows: CTRL + K

For Mac: COMMAND + K

To remove hyperlink in Excel, execute the below steps.

1. Select the cell which has a hyperlink.

2. Rightclick on that cell and click on the Remove link.

This is a simple way to remove hyperlinks in Excel.

After watching the video you can download the below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel.

If you like our tutorial please share it on Facebook and Youtube below.



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials