Excel 表內一次過移除超連結

Lets try this:
1) Select all email cells (if all email address are in column B, you may single click on the 'B' gray column heading to select the entire column)
2) Edit > Clear > Formats

I hope this helps.

Calvin Lee

2009-02-10 20:14:09 補充：
I'm so sorry. Here is a question soulution!

1) Select a column
2) Ctrl + C
3) Find an empy column, say column G, and then select cell G1
4) Edit > Paste special
5) Select Value button (in the first section)
6) Done ^0^

Calvin Lee, [email protected]

按下ctr及用滑鼠左鍵按一下超連結所在的儲存格並拖出需要移除的範圍，然後按一下快顯功能表上的 [清除內容] 指令即可。