C
C-ROB
HOW CAN I MAKE THE CELL TAKE AS MUCH TEXT AS I WANT?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kassie
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
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
P
Peo Sjoblom
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"
"32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar"
D
Dave Peterson
But by adding lots of alt-enters (to force new lines within the cell), you can
see lots more than the documented 1024 characters.
see lots more than the documented 1024 characters.