Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
xmasbob
 
Posts: n/a
Default Display actual contents of cell

In excel I have some very large text entries. When I position on the cell the
entire contents of the cell is displayed but the cell itself truncates the
text when not positioned on the cell. I have tried sizing the cell to
accommodate the text but even thought the cell is bigger and obviously has
white space the text is still truncated. I have a word document that
references via link some of these cells and the text in the word document is
truncatedas well. How can I fix this? Help!
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
Excel has a limit of displaying 1024 characters per cell., To extend
this limit enter some manual linebreaks with ALT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany


xmasbob wrote:
In excel I have some very large text entries. When I position on the
cell the entire contents of the cell is displayed but the cell itself
truncates the text when not positioned on the cell. I have tried
sizing the cell to accommodate the text but even thought the cell is
bigger and obviously has white space the text is still truncated. I
have a word document that references via link some of these cells and
the text in the word document is truncatedas well. How can I fix
this? Help!


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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Display cell value on a chart. Andrew Constantinidis Charts and Charting in Excel 1 January 8th 05 05:36 AM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 02:12 AM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 05:30 AM
How do I automatically rename a sheet with the contents of a cell. michaelspearin Excel Discussion (Misc queries) 3 December 3rd 04 10:27 PM


All times are GMT +1. The time now is 10:11 AM.

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

About Us

"It's about Microsoft Excel"