As Excel users, we were taught that you enter information in the cell and hit Enter.  This actions navigates to the next cell below. It is in the File Options that sets up it to automatically moves down to the next cell when you Enter.  Guess what, if you hit Control+Enter, the information is enter and it REMAINS in that cell. It does not navigate down to the next cell.

Enjoy

Advertisements