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

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.