Excel Hyperlinks: How to Select without Activating

In Excel, when you type an email address into a cell it automatically changes to a Hyperlink. (Tip: to Undo that automation, just hit Ctrl Z immediately after it happens. You can also Right click the hyperlink and choose "Remove Hyperlink")

Anyway, when you type an email address and it automatically changes into a Hyperlink that you want to keep, how do you then select that cell without activating the Hyperlink?

Answer: click and "hold" until the cursor hand changes to a crossbar again.

E-Book by Andy Lanning: Microsoft Office 2010 MUST FIX LIST

NEW!! Get the MS Office 2010 MUST FIX List... Just $7.50 for an E-book that will spare you endless frustration when you upgrade to Office 2010, plus other tips & tricks. I developed this MUST FIX list as a teaching necessity. I couldn’t start class until the students could find their buttons! It’s provided here as a way to give you a jump-start with your new software. (IMPORTANT! At payment screen, when completed, click the yellow bar, labeled: ‘Return to Computer Software Training, LLC’ to initiate the download.)