Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a large spreadsheet where one of the columns has text hyperlinks. They are not clickable though.

I can make them clickable by selecting url text and clicking Insert -> hyperlinks -> webpage.

But this is really tedious if i do it manually. Is there a way to apply this on the entire column?

share|improve this question

1 Answer 1

Apple Numbers had this problem since day one. The easiers way to convert is to copy entire column and paste in text edit (plain text mode) then copy and paste back. It does not work on large collumns. If you have more then 500 cells it will probably not going to work, so try to copy and paste small number of cells. Try 200 or 300 and see if that helps.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.