Ever find yourself about to hit the Enter key in MS Excel and realize you need to move up a cell to fix something?
What did you do?
Most people go ahead and use the Enter key and then use the arrow keys (or mouse) to move back to the cell above.
This works, but doesn’t it seem like there should be a more efficient way? Well, as expected, there is!
Next time you’re in this predicament, try Shift + Enter instead of the plain old Enter.
You’ll find that your data is safely in the cell, but the selection is moved up instead of down. (If you’ve used the Options dialog box to change the direction Enter sends the cell selection then you’ll find that Shift + Enter simply moves in the opposite direction of that setting.)
Two tasks with one key combination. Don’t you just love efficiency?!