close

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.

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 gt;,
Toni D lt;Toni gt; wrote:

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

Thanks JE McGimpsey.

quot;JE McGimpseyquot; wrote:

gt; XL has a limit of 1024 characters that can be displayed or printed in a
gt; cell, even though the max length of a cell is 32767 chars.
gt;
gt; One workaround is to manually enter a linefeed (ALT-ENTER) at least
gt; every 1024 chars.
gt;
gt;
gt; In article gt;,
gt; Toni D lt;Toni gt; wrote:
gt;
gt; gt; Even though I have resized the cells and wrapped text, the total contents of
gt; gt; cells with a lot of data in them are not visible in the worksheet. The full
gt; gt; cell contents are only visible in the formula bar.
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()