logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Change all hyperlinks to =HYPERLINK() formulas

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Web  ›  6. Change all hyperlinks to =HYPERLINK() formulas

This utility will change all hyperlinks in cells to =HYPERLINK() formulas on the selected worksheets.
The current hyperlink address will be use for the hyperlink part. The text from the screen tips will be lost because screentips are not supported by the =HYPERLINK() formula.

Workbooks in Excel can become slow when they contain too much 'normal' cell with hyperlinks. The =HYPERLINK() formula does not have that problem.

Remark:
If the hyperlink address exceeds 255 characters the cell will be skipped, because that is the maximum length allowed by Excel in the =HYPERLINK() formula.

Starting this tool


Download
Activate hyperlinks (create from cell values)...



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us