Do you have cells with hyperlinks? Maybe it's an email address or a web address in a cell that you need to change. Editing that cell is not as easy as simply clicking on it! You see, if you simply click on a cell with a hyperlink, it will open that hyperlink! Excel will open you browser and take you to that website, or open up your email client to send an email to that email address!
There are three ways that quickly come to mind to actually select that cell without activating the hyperlink.
The first method I suggest is based on our Using the Name Box blog post. Just type the address of the cell you want to edit in the name box, and Excel will take you there.
The second method I suggest is to simply click the cell beside that one and navigate using your keyboard arrows to the cell that contains the hyperlink.
The third method is using your mouse cursor to click the cell, but don't simply click it - click and hold it for a few seconds. This will bypass the hyperlink activation and allow you to select the cell.
As you can see, Excel is VERY versatile. There is usually more than one way of doing something. Have you found any different way of getting around this? Leave a comment below and let us know!
Keep Excelling!
Do you like this post? Comment below and / or share on Facebook or Twitter!
No comments:
Post a Comment