how many characters i can put into one cell in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.'
 
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.
 
You must log in or register to reply here.

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
Excel 2003 - Maximum number of characters a cell can contain? 1
How do I increase viewable cell character count limit in Excel? 2
How do I get more than 255 characters into a cell? 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Wrapping text with line breaks problem 1
Transfering one cell of word to excel 2
Excel Cell Height - white space 2

Back
Top