Copy a Hyperlink in Excel—Without Triggering it

BY STANLEY ZAROWIN

All I wanted to do was copy a bunch of hyperlinks from one worksheet into another. But often when I highlight the cell containing the hyperlink, the link gets triggered before it can perform the copy task. Is there a way to prevent that?

Yes, there is a little trick to it. Say the link is in cell B1. Rather than clicking on B1, click on any adjacent cell and then use your arrow keys to expand it to B1; that action won’t trigger the link, and you can then copy it.

 

FEATURE

Maximizing the higher education tax credits

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

SPONSORED REPORT

Solving the lease accounting challenge

The challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.