Did you know that the OpenOffice.org Wiki has a WYSIWYG editor? See Help:FCKeditor

How do I wrap text within a cell in my spreadsheet?

From OpenOffice.org Wiki

Jump to: navigation, search


How do I wrap text within a cell in my spreadsheet?



To wrap text within a cell, or merged set of cells:

  1. Select a cell or group of cells.
  2. Right-click the selected area and go to Format cells..., or select Format - Cells from the main menu
  3. Click on the Alignment tab.
  4. Check the Wrap text automatically (in OpenOffice.org 1.1.x: Automatic line break)
  5. Click OK.
  6. Select 'Optimal Row Height...' from the context menu. Now the contents of the cell will be wrapped to fit the cell.


Personal tools
Create a book