www....com does not stay active in excel 2010

waltdisneypixar · #1 06-10-2012, 02:01 PM

Quote:

Originally Posted by macropod

• 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.

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

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