hi



when i cope anda paste a link:

https://www.msofficeforums.com/newth...newthread&f=12


and then i press enter and becomes blues but i can't press on it

what i have to do is to go to that cell and double click and after i double click

it becomes cliclable

the bad this about this is that i have to press all the links i want to add in my excel and the everytime i doubleclick it opens in firefox

what i want is something much simpler instead of double clicking

Attached Files

Book2.xlsx (8.6 KB, 9 views)

• In a spare column, input: =HYPERLINK(A1)
• Copy down as far as needed
• Select the data in the 'spare' column
• Copy the data
• Use Edit | Paste Special > Values
• Copy the data
• Paste over the original data
• Delete the 'spare' column.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

i;m using it as a movie collector, so every day i insert 2 or 3 movies with www....

i didn't understand what you said

everyday i insert name of the film, year of the film and imdb link

Did you at least try it?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

copy down as far as needed: what do i have to copy?

• Select the data in the 'spare' column: how?

• Copy the data : what do i have to copy, again?

Use Edit | Paste Special > Values : where is it?

• Copy the data : what do i have to copy, again?

If you have to ask those sorts of questions, it suggests you haven't bothered learning even the basics of how to use Excel. I suggest you do a web search for 'Excel basics tutorial' and take some time to learn the basics, at least.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

thank you anyway for your time