70 Combine Multiple Cells into One

 <  Day Day Up  >  

70 Combine Multiple Cells into One

Sometimes you'll need to merge multiple cells into a single cell . Perhaps you want to pad a label with several surrounding blank cells to add spaces that can't be easily removed from the label.

Before You Begin

57 Freeze Row and Column Headers

60 Center a Heading over Multiple Columns


graphics/09inf04.jpg

Not only can Calc merge multiple cells into a single cell, but it can also turn a single cell with multiple values back into multiple cells once again.

TIP

graphics/tipbw_icon.gif

One of the most common reasons to merge two or more cells into a single cell is to center titles over multiple columns (see Center a Heading over Multiple Columns ).


  1. Select Multiple Cells

    Select the cells that you want to merge into a single cell. Generally, this requires that you select empty cells to the right or to the left of one or more labels.

  2. Request Merged Cells

    Select Format, Merge Cells, Define from the menu. Calc merges the cells into a single cell for you.

    NOTE

    graphics/notebw_icon.gif

    If you select cells from two or more rows to merge, Calc merges those cells' contents into a single cell on a single row. Usually, you'll want to merge only adjacent cells from the same row.

  3. Merge Cells from Another Row

    If you have other cells from a subsequent row that you want to merge into one, continue selecting adjacent cells in each row and merging them from the Format, Merge Cells, Define menu. You might do this, for example, if your spreadsheet uses a multiline title atop the data; by merging the title's cells into a single cell, you can more easily center the title over the data.

  4. Reverse the Merge

    To reverse the merge, select Format, Merge Cells, Remove .

 <  Day Day Up  >  


Sams Teach Yourself OpenOffice.org All In One
Sams Teach Yourself OpenOffice.org All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net