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

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.