- 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 29, 2025
				Reputation, security, compliance: Why AI risk disclosures are surging
October 27, 2025
				AICPA releases gen AI tool: Josi
October 23, 2025
				Reflecting on AI’s rise in accounting, looking to what comes next
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.
 
								