ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Text stops wrapping in cell. Tried AutoFit. (https://www.excelbanter.com/excel-worksheet-functions/159782-text-stops-wrapping-cell-tried-autofit.html)

EdC

Text stops wrapping in cell. Tried AutoFit.
 
Entered several lines of text in cell using "wrap text". No problem. After
about 20 lines newly entered text would not wrap. Used AutoFit and there was
no change. Manually expanded the cell and no change. Does anyone know why
text will wrap for 15 + lines then all subsequent text will not wrap? HELP!

Gord Dibben

Text stops wrapping in cell. Tried AutoFit.
 
Excel will allow 32767 characters to be entered in a cell.

But.....only 1024 of these will be visible or can be printed.

Is this your problem?

You can extend this 1024 limit by using a smaller font or adding an Alt + Enter
every 80-100 characters.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 09:36:04 -0700, EdC wrote:

Entered several lines of text in cell using "wrap text". No problem. After
about 20 lines newly entered text would not wrap. Used AutoFit and there was
no change. Manually expanded the cell and no change. Does anyone know why
text will wrap for 15 + lines then all subsequent text will not wrap? HELP!




All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com