Right-click hyperlink options are missing

Yes, sorry for not being clearer! Specifically, the function looks like

Please Login or Register  to view this content.

Where I4 is a page identifier in the adjacent column.

That doesn't work for me. It just progresses to the cell underneath. Shift+enter, ctrl+enter, and ctrl+shift+enter also don't work (this is true for the copy-pasted hyperlinks as well as the =hyperlink() links).

Currently, the only way I have found to access the =hyperlink() hyperlinks is by left-clicking once with the mouse, but I would really like to be able to open them using keyboard only, as I am able to do with the copy-pasted ones.

I tried that and it doesn't work for me. I am using Office 2010 and a google search suggests that other 2010 users have had this problem with "enter" not opening hyperlinks. This thread tells someone with the same problem to use the shortcut key between alt and ctrl to the right of the keyboard to pull up the options menu as a workaround, but that is exactly the problem I am having-- I don't have the "open hyperlink" option in that menu.

I guess I don't understand what you mean by "It's not a hyperlink in the same way." I was unaware that there are different types of hyperlinks, in terms of their functionality and beyond just how they are created (i.e., using the =hyperlink() function as opposed to right-clicking and adding the hyperlink via the navigation box).

Do I understand correctly that using the =hyperlink() function simply cannot, and will not ever, allow me to right-click and use the "open hyperlink" option? And that if I am unable to open it with the enter key, as you are able to do, the only way to open the hyperlink is to left-click it? If that is the case, is there any way to convert the =hyperlink() links to the format that will allow me to open it via keyboard commands?

I apologize if I am missing something obvious, but I keep getting more confused!

Thank you both for explaining that... I searched all over and couldn't find a thing! I guess I will indeed have to do some sort of code to get around it, because I agree-- the formula hyperlinks are better than the embedded ones.