Excel - Entering long text in a Cell

While entering text in any cell, the existing space frequently proves inadequate. If there is nothing in the adjacent cell, the contents just spill over, otherwise the text is hidden. The simplest option is to extend the width of the column – Go to the column head (depicted by an alphabet), go to the right edge and watch the cursor change shape. Click and Drag to as wide as you would like; double click to allow the software to automatically go to the maximum required.

However you may like the contents to fit onto the width selected by you. If so, Format the Cell and select the option Wrap Text.

Having typed a lot, you might want to split it into another paragraph – just press Alt and Enter together at the required place.

And if you have already moved onto another cell but want to add some more text go back to the cell, click anywhere and then press End to reach the last word. Or simply press F2 to add at the end while on the spreadsheet itself - this works directly on the keyboard without even using the mouse so is quite fast.