Move Up After Editing in Excel Spreadsheets

As we know, by default, pressing Enter after editing will move to the cell directly below. Whereas, pressing Tab after editing will move to the cell directly to the right.
If you press Shift + Enter after editing, Excel moves to the next cell up instead. This may be useful depending on how the data is structured in the spreadsheet.
Note: In the Options, you can change the behaviour of the Enter key when editing cells to move up, right, down or left. But we like to stick with the defaults.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.