I would like to turn off hyperlinks for an entire columns. Is that possible?

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/

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/

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

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

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/

That seems to work. Also good when you need to split the list into several lists.