Text Wrapping

Text Wrapping

Text wrapping is a feature that continues text on a new line when a line is full so that it fits within certain desirable constraints. By default, cell input is set to [spreadsheetlivedev:Overflow to Adjacent Cells]. With text wrapping, it will stop the text at the end of the input cell and begin on the next cell below the input cell (see images below).

Image 1 - An example of overflowing text and wrapped text.

There are two methods of assigning text wrapping to a cell. First, you can select the cell(s) that you would like to wrap text within and then press the 'Wrap Text' button in the toolbar. (Note: make sure your toolbar is visible, see [spreadsheetlivedev:Hide Toolbar]).

Image 2 - The 'Wrap Text' button in the toolbar.

Alternatively, you can select the cell(s) that you would like wrapped and then select 'Format' from the top menu of the SpreadsheetLIVE user interface and then select 'Cells'. From here, select the 'Alignment' tab and then check the 'Wrap Text' option. Then press 'OK'.

Image 3 - The 'Wrap Text' option in the 'Alignment' tab of the 'Format Cells' menu.