MS EXCEL 2016 (HYPERLINK CREATION & DELETE)

Hello Everyone!

So, Let's move further in our tutorial of MS EXCEL. Today we are going to talk about the Hyperlink Creation in EXCEL SHEETS.

This Excel tutorial explains how to create a hyperlink to another cell in Excel 2016.

For Creating a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Select Hyperlink from the popup menu.

Now the INSERT HYPERLINK WINDOW will appear click on the "Place In This Document" on the left. Enter the text to display.

Next enter the cell reference that the hyperlink points to.

Now when you return to the spreadsheet, you will see the hyperlink.

If you click on the hyperlink, your active cell will become sheet1;A

Now we are going to see how can we delete the create hyperlink:

Here we have a hyperlink in cell B2 which we want to remove.

To remove a hyperlink from a cell, right click on the cell that has the hyperlink and select Remove Hyperlink from the popup menu.

Now when you return to the spreadsheet, you will see the hyperlink has been removed. In this example, cell B2 appears as regular text and no longer has a hyperlink.

So this is it for Now!

I Will Keep Updating!

Stay Updated!