by Ryan Johnson, I-Tech

If a string exceeds the width of a cell, then it will extend into those adjacent. This can be overcome by wrapping the text so it fits within a single cell.

To have text wrapping enabled by default, first load a new spreadsheet and go to the Home tab on the ribbon and within the Styles group right-click Normal. Click Modify… and then Format. Switch to the Alignment tab, tick Wrap text and click OK twice.

This will change the setting on the current spreadsheet only.