#1
|
|||
|
|||
www....com does not stay active in excel 2010
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 Last edited by waltdisneypixar; 06-06-2012 at 01:57 AM. |
#2
|
||||
|
||||
• 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] |
#3
|
|||
|
|||
Quote:
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 |
#4
|
||||
|
||||
Did you at least try it?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
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? |
#6
|
||||
|
||||
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] |
#7
|
|||
|
|||
thank you anyway for your time
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2010 and Excel 2010 Mail merge - multiple headers | robby | Word | 3 | 04-18-2012 06:37 PM |
Stay on One Page - 100% | mnp | Word | 1 | 12-30-2011 11:57 AM |
can't get text to stay aligned for printing | cherd | Word | 1 | 10-06-2011 03:20 AM |
VB Code in Excel Active worksheet | shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |
Auto Correct to Stay On | sanzlink | Word | 1 | 01-16-2009 06:49 AM |