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?
Last edited by rpjd1971; 06-05-2010 at 08:38 PM.
not sure if this is proper way to do it but if you put " " in front and at back of paste and hit enter it will hyperlink
actually if you hold Ctrl + ' enter it will hyperlink
just tried this -- paste then double click at the start of the address and hit Ctrl + enter and it will hyperlink
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks