They could apply that idea: "Click and hold a second" could enable hyperjumping so releasing and clicking the cell again (no holding) would hyperjump you like clicking a cell with "=E17" in it would. However "Click and hold a second" lets the cell simply be selected, like arrowing into it would. if one has an actual hyperlink (formuala or "true") in a cell, clicking on it goes to the link place. Perhaps if Excel changed to allow Ctrl-Click to hyperjump, there'd be no conflict. Right now it looks like your difficulty exists because Excel resolves the double-click by preferring to enter the in-cell editing mode and so never considers hyperjumping you. I'm sure it would actually require they modify the hyperjump feature itself, not INDIRECT(), but if they DID modify the function instead, that'd be even nicer. (Or if the other addresses are used by the function to build the resulting address. Personally, I wish they'd let this kind of hyperjump occur when the only address specified happens to be built using INDIRECT().
No more work than someone has to do if wanting to hyperjump to some cell using a cell formula that has two or more addresses in it. (Any spot in the characters not just like between "E" and "1" in "E1" but even the portion with a sheet name or other file name. Is this a knows issue, and what is the better would be them letting you enter the cell, and then if you double-click a cell address, you'd hyperlink there. Select Open selected file types in Protected View and allow editing. In the Trust Center, click File Block Settings. Click Trust Center and then click Trust Center Settings. Sometimes, I can’t even use my keyboard arrow to move the cursor so I actually have to delete all the information to the right of what I want edited and then retype all that information again. Click on ‘Options’ the Options dialog box appears. Now, if I want to edit a cell, I can click on the cell, but I can only use the left arrow to move to the area I want to edit, since using my mouse pointer has no impact on moving the cursor while I am trying to edit the cell. This should have no impact regarding my issue because you should have the ability to edit a cell using the formula bar whether or not that box is checked. I prefer to uncheck the Advanced feature of "allow editing directly in cells" because if I have a formula referencing another cell, I like to be taken to the referenced cell when I double click. The cursor stays all the way to the right of the cell contents. When I click anywhere in the formula bar, my cursor will not move to the location where I need to make the edit. I have a bug that started less than a week ago where I can not make cell edits in the formula bar.