As we know, the hyperlinks in Excel contain two parts, one is the hyperlink address, and the other is the display text. In some cases, you may want to rename all display text of the hyperlinks. How can you quickly handle this job? Here in this tutorial, it provides two methods on renaming hyperlinks in two different case:
If you want to change the display text of hyperlinks based on another column values, you can use below formula
In the formula, A1 is the address location, B1 is the display text.
Press Enter key and drag the auto fill handle over the cells to apply this formula.
You maybe interested in this utility:
Batch convert hyperlinks to text contents or extract hyperlinks from cells
If you want to replace the cell contents with the hyperlink addresses, you can choose the Cell contents replace hyperlinks addresses option in Convert Hyperlinks utility of Kutools for Excel, if you want to extract all hyperlinks from a range of cells, chose the Hyperlink addresses replace cell contents option. Click for 30 days free trial!
Create a hyperlink to a chart in Excel In Excel, creating a hyperlink is easy for most of users, but have you ever tried to create hyperlink to a chart in Excel which means that click at a value and then link to a chart in another sheet? Generally, there is no way to directly create a hyperlink to a chart, but here, in this article, I can introduce an interested way to solve it.
Prevent/disable automatic hyperlinks in Excel As we all known, Excel create clickable hyperlinks automatically when we input the web addresses into cells. Maybe, sometimes, this is somewhat annoying. Today, I will introduce some quick tricks for you to prevent automatic hyperlinks in Excel.
Convert multiple email addresses to hyperlinks in Excel If you have a list of plain text email addresses in a worksheet, and now, you want to convert theses email addresses to hyperlinks that you can send emails while clicking the addresses. Of course, you can convert them to hyperlinked email addresses, but, this method will be boring if there are multiple addresses needed to be converted. In this article, I will talk about some good tricks to deal with this task.