HOW CAN I MAKE THE CELL TAKE AS MUCH TEXT AS I WANT?

One way is to right click on the cell, click on Format Cells, Click on
Alignment, click on wrap text. This will keep your text within the cell
borders, but will of course stretch it vertically

Another way is to press <Alt<Enter where you want it to wrap. This means
that your text will not necessarily remain within the cell boundaries.

Another way is, after you have pressed <Enter, to return to the cell,
select a range of cells, whether in one row, or in several rows, where you
think the text will fit (e.g. with your text in A1, select A1:G3), now click
on Edit|Fill|Justify. This will
split your text into three rows, in A1:A3.

"C-ROB" wrote:

HOW CAN I MAKE THE CELL TAKE AS MUCH TEXT AS I WANT?

Look in help for specifications, a direct quote from help"
"32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar"

--
Regards,

Peo Sjoblom


"C-ROB" wrote in message
...
HOW CAN I MAKE THE CELL TAKE AS MUCH TEXT AS I WANT?

But by adding lots of alt-enters (to force new lines within the cell), you can
see lots more than the documented 1024 characters.

Peo Sjoblom wrote:

Look in help for specifications, a direct quote from help"
"32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar"

--
Regards,

Peo Sjoblom

"C-ROB" wrote in message
...
HOW CAN I MAKE THE CELL TAKE AS MUCH TEXT AS I WANT?

--

Dave Peterson