Excel 2007 ; hypelinks

Microsoft Excel 2007
October 21, 2009 at 11:51:12
Specs: Windows XP, 3.194 GHz / 2037 MB
I would like to turn off hyperlinks for an entire columns. Is that possible?

See More: Excel 2007 ; hypelinks

Report •


#1
October 21, 2009 at 11:56:06
Try this:

Click the Office button
Click Excel Options
Click Proofing ( left of the dialog box.)
Click AutoCorrect Options.
Make sure the AutoFormat As You Type tab is selected.
Un-Check the Internet and Network Paths With Hyperlinks box.

That will do it for the entire sheet.
Not sure how you could do it for a single column unless there is a VBA solution.

MIKE

http://www.skeptic.com/


Report •

#2
October 21, 2009 at 12:01:44
Also, putting an apostrophe at the beginning will force Excel to treat it as text.
And you could always press Ctrl+Z after the hyperlink is created.

But for a whole column, VBA is the way to go.

MIKE

http://www.skeptic.com/


Report •

#3
October 21, 2009 at 12:05:20
I have lists with columns of web addresses and email addresses that I need to copy and paste and I don't need the web pages or new mail screen to come up

Report •

Related Solutions

#4
October 21, 2009 at 12:12:29
VBA is not an option as I am at this company temporarily. Apostrophe no good as we need to present these lists to another party and they need to be accurate

Report •

#5
October 21, 2009 at 12:42:23
If you already have the list then
just make cell B1 equal to cell A1

do a copy -
past special, values only

and it should strip out the hyperlinking.

MIKE

http://www.skeptic.com/


Report •

#6
October 21, 2009 at 13:01:44
That seems to work. Also good when you need to split the list into several lists.

Report •


Ask Question