I'm copying hyperlinks from webpages into excel 2007, however the link only appear as plain text, not as a hyperlink. I have to format the actual cell as a hyperlink after pasting. I would like to use Paste as Hyperlink but its greyed out. If I choose Paste Special I only have paste as Unicode or Text. Is there a way of enabling Paste as Hyperlink?
Bookmarks