Maximum Characters in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that a cell in Excel will only display 1024 characters... However, if
you merge 2 cells will it double the size of the viewable space?
 
Nope. But it shouldn't take too long to test it.

But if you add alt-enters every 80-100 characters to force newlines within the
cell, you'll see more text.

You may have to adjust the rowheight manually, though.
 

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

Error message is Character Limit is over 1024 characters 2
How do I increase viewable cell character count limit in Excel? 2
Number of characters in a cell (one row, merged columns) 1
Excel 2003 - Maximum number of characters a cell can contain? 1
Troubleshoot help 3
Replace weird character 2
Microsoft Excel Cell text limits 3
Chracter Limit Help!! 7

Back
Top