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.

 

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

Learn to choose between ‘who’ and ‘whom’

Writers can stumble over who and whom (or whoever and whomever). If you write for business, this quiz can help make your copy above reproach.