Hi all..
I'm finding Numbers to be a good spreadsheet after using Excel for some time on Windows.
However, unlike Excel, Numbers is causing problems for me.
If the source text your cutting from is from a website (prseumebly this the only thing i can think of as the problem), I'm finding it may not always be pasted in the same cell because the cell height may not be wide enough to fit the copied text in, (aka, if the orional text was in a table on a webpage) so it tends to separate to the rest to the the following rows if the cell height is not enogh to fit it all in. eg Cell A9 some text Cell A10 some other text, even though it should all be in one cell
If i make the cell much larger than it would be to fit in text, it sometimes works but not always....While at other times text can easily fit in a small space, but the cell must be almost double the size, which means a got a lot of white space u cannot reduce the cell since it came (presumably) from a table (I'm guessing tables are a cause for this).. I tried "merge cells" which does work, but i still have all that empty white space i cannot shrink. If i must do this, then so be it, but i also don't want an overly large cell when the text can easily fit in much smaller one.
I even trying copying to clipboard and pasting in the cell, but it still spanned to rows.
so, how can i overcome this...?
I'm finding Numbers to be a good spreadsheet after using Excel for some time on Windows.
However, unlike Excel, Numbers is causing problems for me.
If the source text your cutting from is from a website (prseumebly this the only thing i can think of as the problem), I'm finding it may not always be pasted in the same cell because the cell height may not be wide enough to fit the copied text in, (aka, if the orional text was in a table on a webpage) so it tends to separate to the rest to the the following rows if the cell height is not enogh to fit it all in. eg Cell A9 some text Cell A10 some other text, even though it should all be in one cell
If i make the cell much larger than it would be to fit in text, it sometimes works but not always....While at other times text can easily fit in a small space, but the cell must be almost double the size, which means a got a lot of white space u cannot reduce the cell since it came (presumably) from a table (I'm guessing tables are a cause for this).. I tried "merge cells" which does work, but i still have all that empty white space i cannot shrink. If i must do this, then so be it, but i also don't want an overly large cell when the text can easily fit in much smaller one.
I even trying copying to clipboard and pasting in the cell, but it still spanned to rows.
so, how can i overcome this...?