At 18:04 13/10/2010 +0530, Anand Warik wrote:
In spreadsheet Whenever i copy a long sentence & paste it in one
cell instead of having every thing in one cell itself the sentence
is split & pasted in number of rows. I want everything to remain in one cell.
Like others, I am puzzled: if the original text is continuous and not
formatted as a number of paragraphs, I don't find this happens.
But in any case, in addition to the suggestions already made, there
is a convenient workaround.
o Select all the cells into which the text has been pasted.
o Go to Format | Merge Cells (or click the Merge Cells button in the
Formatting toolbar).
o Answer "Yes" to "Should the contents of the hidden cells be moved
to the first cell?". (Note that Calc will even add intervening
spaces.) The text is now in a single merged cell.
o Go to Format | Merge Cells again (or click the Merge Cells button
in the Formatting toolbar again) to unmerge the cells and return the
text to the first of the cells - where you want it.
(Oh, and to those who enjoy such things: you can't do that, I think, in Excel!)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
