Aha, I found the place in "paste special" where you choose to move cells
down or left and that worked. I copied the specific cells instead of the
whole row, chose "paste special" and chose to "move cells down" and in
they went.
Thanks to all for all their help on this.
As to the colors, I'm sorry - I didn't explain that well. It wasn't
visible on the formatting toolbar, you had to click the little arrow at
the end to see it, but when I picked it it didn't give the color
palatte. I had to choose to add it to the menu. then I got a very
confusing set of instructions that I seem to remember from very old
versions of microsoft products on dragging something here, and cutting
something there... however, when I went back to the menu, somehow,
without all that cutting pasting and dragging, it managed to show up on
there, LOL. And now it works. sheesh.
Brian Barker wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
