Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toni D
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toni D
 
Posts: n/a
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell data format falloutx Excel Discussion (Misc queries) 1 February 10th 06 01:46 PM
In Excel formatted wrapped text displays as xxx in cell Linda Excel Discussion (Misc queries) 1 January 26th 06 06:53 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
tried using SUBTOTAL function (XL XP) and it doesn't seem to work JethroUK© New Users to Excel 12 August 22nd 05 07:33 PM
Using a Text / Data output as a cell reference Jimboski Excel Discussion (Misc queries) 1 February 11th 05 07:31 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"