ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cell data not visible (I have wrapped text & resized) (https://www.excelbanter.com/excel-worksheet-functions/77130-cell-data-not-visible-i-have-wrapped-text-resized.html)

Toni D

Cell data not visible (I have wrapped text & resized)
 
Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.

JE McGimpsey

Cell data not visible (I have wrapped text & resized)
 
XL has a limit of 1024 characters that can be displayed or printed in a
cell, even though the max length of a cell is 32767 chars.

One workaround is to manually enter a linefeed (ALT-ENTER) at least
every 1024 chars.


In article ,
Toni D <Toni wrote:

Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.


Toni D

Cell data not visible (I have wrapped text & resized)
 
Thanks JE McGimpsey.

"JE McGimpsey" wrote:

XL has a limit of 1024 characters that can be displayed or printed in a
cell, even though the max length of a cell is 32767 chars.

One workaround is to manually enter a linefeed (ALT-ENTER) at least
every 1024 chars.


In article ,
Toni D <Toni wrote:

Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.




All times are GMT +1. The time now is 02:37 AM.

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