When I enter a formula in Excel, I often want to finish up the data entry and stay on the same cell so I can see formula in the cell and the result of the calculation at the same time. If I press Enter (or Tab) I move away from the cell and then need to use an arrow key to go back to it.
How do I finish the data entry and stay on the same cell? Press Ctrl+Enter.