- column
- 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
October 2, 2025
AI-driven spreadsheet tools — what CPAs need to know
October 2, 2025
Car talk: M&A, AI and EVs changing the dealership landscape
October 2, 2025
Is spending on technology spinning out of control?
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.