Because Excel's primary purpose is to display, organize and calculate numerical data such as your business' profits or expenses, the "Enter" key confirms a cell's contents and moves to the next rather ...

When you enter longer text than will fit in a normal Excel cell, the excess text either carries over into the next blank cell or is truncated by adjacent data. You have several options to remedy this.