1. column
  2. TECHNOLOGY Q&A

Copy a Hyperlink in Excel—Without Triggering it

BY STANLEY ZAROWIN

Please note: This item is from our archives and was published in 2009. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

TOPICS

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.