ASAP Utilities, description of our Excel tools

Language:

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

Web » Activate hyperlinks (create from cell values)... (Click to zoom)

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

Excel 2010 with ASAP Utilities in the menu

Download ASAP Utitilities

Additional keywords for this tool:
reactivate hyperlinks, convert hyperlinks

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our "tip of the week" at: