The ASAP Utilities menu in Excel (English)
Change all hyperlinks to =HYPERLINK() formulas
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語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.
Note:
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
- Click ASAP Utilities › Web › 6. Change all hyperlinks to =HYPERLINK() formulas
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.