The Right Way to Delete Hyperlinks

BY STANLEY ZAROWIN

Q. After reading your wonderful technology columns, I took your advice and added some hyperlinks in an Excel file. One hyperlink connected me to a Web site and the other linked a cell to another cell in a different Excel file. They worked fine—except for one small problem: Now I can’t get rid of them. I tried to erase them but got no place. Help.

A. I’m sorry, I should have warned you about what you discovered the hard way: You can’t just erase a hyperlink by pressing the Delete key; that just removes the information in the cell, but not the hyperlink. If you type something in the cell again, it will be underlined, indicating that it’s still a hyperlink.

To erase a link, follow these steps: Put your cursor in the cell that contains the hyperlink and right-click on it. That produces a menu with a Remove Hyperlink option.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

News quiz: Tax-related data breach explained

News about a data breach that affected about 100,000 people, the IRS’s budget for the fiscal year, and the 2018 health spending account limits received attention recently. See how much you know with this short quiz.