how many characters i can put into one cell in Excel

G

Guest

If i typed a whole paragraph into one cell of Excel, only a part of para show
up in that cell. I tried wrap text, increase the height of the column.
Nothing happen.
Any one have idea about it or there are some limit to view in Excel in one
cell
 
G

Guest

Hi
Search for 'specifications' in Help:
It says '32,767 characters. Only 1,024 display in a cell; all 32,767 display
in the formula bar.'
 
D

Dave Peterson

But that note about 1024 displaying in a cell is not correct. You can see lots
more if you add alt-enters (to force new lines within the cell) every 80 or 100
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

Cell format - wrap text 7
Transfering one cell of word to excel 2
Excel 2003 - Maximum number of characters a cell can contain? 1
# of Characters/cell 2
How do I get more than 255 characters into a cell? 3
Excel - text in cell coming out all # signs. Help. 2
How many number digits can I fit into one cell? 3
Wrapping text with line breaks problem 1

Top