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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
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