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

waltdisneypixar · #4 06-11-2012, 12:32 AM

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.

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?

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