 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2007large text in a cell?
Is there a limit to how much text you can have in a cell? Can you expand that limit? I have a column of data where each cell of that column has a lot of text in it. I have not been able to get the cells in that column (with large text) to display or print the text in those cells- no matter how large i expand the column or the row... any ideas Thanks brent The limit is 32767 characters. Prior to XL07, the display limit is 1024 characters. You can extend that by inserting a manual linefeed (CHAR(10)) every 1024 characters. > Is there a limit to how much text you can have in a cell? Can you expand > that limit? [quoted text clipped - 3 lines] > to display or print the text in those cells- no matter how large i expand > the column or the row... To insert a manual linefeed, do I do an <alt> enter? What about spliting the cell? How about linking an object (notbook or word text item) to that cell? Thanks Brent > The limit is 32767 characters. Prior to XL07, the display limit is 1024 > characters. You can extend that by inserting a manual linefeed [quoted text clipped - 9 lines] >> to display or print the text in those cells- no matter how large i expand >> the column or the row... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.