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...

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

Activate hyperlinks (create from cell values)...

Remove all hyperlinks in selected cells

Download

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years