View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason[_14_] Jason[_14_] is offline
external usenet poster
 
Posts: 21
Default Cells only display a maximum number of text characters

A cell can contain up to 32,767 characters, but the number it can
*display* at any one time is limited by screen size/set up etc.

If you are wanting to display more then it appears you are not using
excel as a spreadsheet, but rather a word processor.


SteveMCFC wrote:
Because of the convenience of being able to filter, sort and hide rows and
columns, when using Excel instead of Word for creating documents with several
columns, I've noticed that even though "Format Cells Wrap text" is set, a
single cell will only display a maximum number of characters, maybe 1300 or
so (which may sound a lot!!). The same applies if the "spreadsheet" is
printed. How do I format the cell to allow an unlimited number of characters
to be displayed\printed?