ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Web » Activate hyperlinks (create from cell values)...

This utility adds a hyperlink in the selected cells based on content of the cell.
You can use this for example to transform website- or email addresses into clickable hyperlinks.

You can configure the following settings:

Font format:

Keep the existing font format in the cells.

Use Excel's default format for hyperlinks (blue underlined)

Hyperlink type:

Use the =HYPERLINK() formula. This is recommended if you have a lot of hyperlinks in your file or if you use a shared workbook.

Regular hyperlinks (via the cell properties)

Your last used settings will be remembered.

Screenshots

Starting this utility

In the Excel menu choose: ASAP Utilities » Web » Activate hyperlinks (create from cell values)...

« Return to the list of “Web” tools.

« Previous
Extract hyperlinks...

Next »
Change all hyperlinks to =HYPERLINK() formulas

You can do this too

Download "The one essential add-in for all Excel users."

Additional keywords for this tool:
reactivate hyperlinks, convert hyperlinks

Printer friendly page

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at: