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;
- Sep 29 Fri 2006 20:09
Cell data not visible (I have wrapped text amp; resized)
close
全站熱搜
留言列表
發表留言