TEXT SHOWS UP IN FORMULA BAR BUT NOT IN CELL?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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"
 
But by adding lots of alt-enters (to force new lines within the cell), you can
see lots more than the documented 1024 characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top