At 15:54 20/11/2008 +0100, Guy Voets wrote:
2008/11/20 Bill Drescher
Brian Barker wrote:
There are two solutions: either copy the actual cells you need
rather than rows or columns; or demerge the problem cells, paste
the material, and merge the necessary cells again.
Brian, how does one demerge cells ?
--
Bill Drescher
Hello Bill,
I believe you split cells from the same menu item you use to merge
them. Put your cursor in the cell to be split again, go to Format >
Merge Cells and click on the item to remove the check sign. The cell
will split.
HTH
--
Guy
There's your answer! But here are a few other points:
o There is also a Merge Cells button in the Formatting toolbar.
o You may not need to select the exact merged cells if you wish to
demerge one or more cells. If you select a range of cells which
includes any merged cells and then use Merge Cells, the effect is to
demerge all the merged cells within the range. A second use of Merge
Cells will merge all the selected cells.
o Merging and demerging cells can be a convenient way of combining
material in adjacent cells. Select a number of cells, click Merge
Cells, accept the offer to move the contents of the hidden cells into
the first cell, and then immediately demerge them. The material in
the cells will be concatenated with intervening spaces. Calc will
even let you combine values of different types - text and numbers, maybe.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
