9 {{ upvoteCount | shortNum }}
9 {{ upvoteCount | shortNum }}

how to make a list of urls in open office clickable

by high_plains_drifter
6 replies
  • SEO
    • |
ive pasted a list of urls into open office calc and need them all to be clickable

anyone know how to do this?
#clickable #list #make #office #open #urls
  • Profile picture of the author yukon
    Banned
    You have to use the little hyperlink icon in the toolbar at the top middle of the page. Then assign a URL + Anchor-text for each individual link.

    You'll get a pop-up window to add the URL/anchor-text.

    If you highlight the word (anchor-text) first, the pop-up will already have the anchor-text filled in for you, then just add the url & click the apply button on the pop-up.
    {{ DiscussionBoard.errors[5051709].message }}
    • Profile picture of the author high_plains_drifter
      Originally Posted by yukon View Post

      You have to use the little hyperlink icon in the toolbar at the top middle of the page. Then assign a URL + Anchor-text for each individual link.

      You'll get a pop-up window to add the URL/anchor-text.

      If you highlight the word (anchor-text) first, the pop-up will already have the anchor-text filled in for you, then just add the url & click the apply button on the pop-up.
      i have 1000's of url's surely there is a quicker way?
      Signature
      {{ DiscussionBoard.errors[5051751].message }}
  • Profile picture of the author yukon
    Banned
    Actually I just tested a copy & paste URL, then saved as a PDF in OpenOffice & the URL was clickable.

    If you don't care about the anchor-text, it should work as the URL being clickable, worked for me.
    {{ DiscussionBoard.errors[5051740].message }}
  • Profile picture of the author yukon
    Banned
    Hmmm... I know that emails are automatically converted to hyperlinks from a copy & paste, so there should be a way to import a long list of regular hyperlinks.

    Are you saving as a CSV file?
    {{ DiscussionBoard.errors[5051914].message }}
  • Profile picture of the author high_plains_drifter
    sorted

    just paste =HYPERLINK($A1) in the next cloumn
    Signature
    {{ DiscussionBoard.errors[5052054].message }}

Trending Topics