Re: Text limits in cell?

D

David McRitchie

Hi Tim,
Wrap is an option in Format, cells, alignment
you get an automatic wrap if you use ALT+Enter to force a
new line in a cell.

Look in HELP, index (tab), specifications
you can extend the display limit within cells by entering your own ALT+Enter
to force a new line.

Length of cell contents (text)
32,767 characters.
Only 1,024 display in a cell; all 32,767 display in the formula bar.

Length of formula contents 1,024 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

Similar Threads

limit on cell contents 1
Spell check / character cell limit 2
Problem printing a large excel cell 5
Cell Text not fully visible in Formula Bar 3
Beyond 1024 cell content limit 6
Excel 2007 Character Display 2
Chracter Limit Help!! 7
need way to handle large csv imports that overflow cell size 3

Top