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.