Clear Hyperlinks and Formatting in Excel

Type an email address or website address in Excel and it automatically turns into a hyperlink.  Click on that cell to select it and a blank email message  appears.   All you wanted to do was copy that cell or range. What a pain!

Good news! You can remove the hyperlink and the hyperlink formatting. And you can do so for a range. No more removing one hyperlink at a time. The secret is the Clear command on the Home ribbon, in the Editing group.

Select the cell or range. Select Clear. Then Remove Hyperlinks.

No more hyperlinks or hyperlink formatting.