LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how much is too much data for a cell?

Thanks again for answering.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"evilyn" wrote in message
...
it worked when i put it forced line breaks. the character count is
2094 which makes it even more odd that it would not all show up.

On Dec 3, 6:08 pm, "RagDyer" wrote:
Appreciate the feed-back.

Would also appreciate your max character count with this procedure if in
excess of 5,000.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"evilyn"
wrote in message

...



Thanks. I'll try that.


On Nov 30, 5:07 pm, "RagDyer" wrote:
I don't know the exact number of characters that will actually
display,
but
I've been able to get over 5,000 to show by placing forced line breaks
(
<Alt <Enter) at appropriate places throughout the text.
--
HTH,


RD


---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !
---------------------------------------------------------------------------


"evilyn" wrote in message


...


a cell should hold 32,000 characters if i am not mistaken. i have a
large spreadsheet that has codes, their use, description and the #
of
times they have been 'hit'. most of the information fits in a cell
very easily but i have one description that is huge. i made the
cell
255x409 which is the max and what happened was part of the
information
showed and then the rest of the cell was blank. at that cell size
there was more than enough room for all the data but for some reason
it would not all show. i tried things like changing the alignment
and
it is on wrap text. i tried selecting all the data and making it a
different smaller font. but nothing seems to work. its probably a
simple fix but...too complicated for me obviously. i have the excel
2003 bible but couldn't find my answer in there either. any and all
help is greatly appreciated.- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -




 
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
moving data to a cell, not pulling data to the cell Yojinbou Excel Worksheet Functions 2 November 27th 06 07:32 PM
Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) Tom-LE Excel Discussion (Misc queries) 0 August 30th 06 10:10 PM
cell data not validated if navigating cell to cell with mouse LoveThatMouse Excel Worksheet Functions 6 May 21st 06 09:03 PM
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data confuzedagain Excel Discussion (Misc queries) 1 December 7th 05 05:56 PM
The match and lookup functions can find literal data but not the same data referenced from a cell Jeff Melvaine Excel Discussion (Misc queries) 3 April 30th 05 01:29 PM


All times are GMT +1. The time now is 01:18 AM.

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"