hyperlink; format

  1. Sprock

    Imported Hyperlinks lose link

    I am VBA noob extraordinaire. I am merging data from multiple WBs. The Source WBs and destination WB are .xls. In all the source WBs, the D column contains hyperlinks that work in the source but after copy in the destination the Address is missing from the Hyperlink properties. Here is...
  2. B

    Find Hperlinks in column and copy entire row to new sheet

    I have a group of worksheets that I want to cycle through and look in column A for a hyperlink. If the cell has a hyper link in it I want to copy the entire row to the work sheet pTable. I have pieced the code below together as a first step to copy the just the link but it does not work with the...
  3. B

    Converting Hyperlinks to URL

    Q? I have a several hundred entity names that each function as a hyperlink. Each name is associated with a distinct web URL. While this is cool, I want to format the cells to show only the web URL. How do I convert these hyperlinks to the URL address? Is their a paste special function or command...
  4. B

    Hyperlink alignment

    If I have a hyperlink that is set up to reference a cell in the same sheet, is there a way to make the referenced cell appear as the top left cell on the screen?
  5. C

    Hyperlink formatting

    Simple question - When you create a hyperlink in excel, it automatically makes the text blue with underlining - is there anyway to change this? I've looked everywhere but can't seem to find an answer!

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top