logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Extract Hyperlink Addresses from Cells and Shapes...

ASAP Utilities  › Web Data  ›  4. Extract Hyperlink Addresses from Cells and Shapes...

This tool extracts the hyperlink addresses from cells and shapes on your current worksheet and places them into regular cells. It works with all types of hyperlinks that Excel supports, such as:
  • Web addresses (URLs)
  • Email addresses (mailto:)
  • Links to a place in your workbook (like a specific cell or sheet)
  • Links to files or folders on your computer or network You can choose to get the hyperlinks from:
  • The selected cells
  • All shapes or images on the worksheet that contain a hyperlink Shapes can include:
  • AutoShapes
  • Freeforms
  • Pictures
  • OLE objects You can choose where to place the extracted hyperlink address:
  • In the original cell, leaving the hyperlink itself unchanged
  • In the column directly next to the cell or shape (any existing value will be overwritten) This tool is useful when you want to extract, review, or export hyperlink addresses from cells or clickable shapes, without opening or editing each one manually. Your last used settings are automatically remembered for quick reuse. Tip:  
    If you want to read a hyperlink address directly from a cell using a formula, you can also use the ASAP Utilities worksheet function:
    =ASAPGETHYPERLINK()

    Screenshots

    Web Data  ›  4 Extract Hyperlink Addresses from Cells and Shapes...

    Starting this tool


    Web Data  ›  4 Extract Hyperlink Addresses from Cells and Shapes...
    Additional keywords for this tool:
    Extract hyperlink addresses, Extract links from cells, Extract URLs from cells, Get hyperlink address from cell, Extract email addresses from hyperlinks, Extract links from shapes, Extract links from pictures, List all hyperlinks in Excel, Export hyperlinks from Excel, Get URL from hyperlink, Extract mailto links, Get cell link address, Extract internal links, Extract hyperlinks to next column, Read hyperlink from shape, Extract link without removing hyperlink, Extract hyperlinks from Excel images, Extract hyperlink formula, Extract hyperlinks from selected cells, Show hyperlinks



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


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.