Doing that I would navigate to the next Excel workbook.

No, you don't when you are in Edit mode. But the character ISN'T inserted into
the cell, either.