Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
r r is offline
external usenet poster
 
Posts: 125
Default format cells to display 20 long sentences in a single cell

Even if i format the cell (in exel sheet) as wrap text, the cell does not
display long sentences completly. It only displays a part of the sentence.
This happens after entering say 20 or more lines.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default format cells to display 20 long sentences in a single cell

r

From help

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

You could use a text box if this helps

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"r" wrote in message
...
Even if i format the cell (in exel sheet) as wrap text, the cell does not
display long sentences completly. It only displays a part of the sentence.
This happens after entering say 20 or more lines.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default format cells to display 20 long sentences in a single cell

If you add alt-enters every 80-100 characters to force new lines within the
cell, you'll see lots more characters.

r wrote:

Even if i format the cell (in exel sheet) as wrap text, the cell does not
display long sentences completly. It only displays a part of the sentence.
This happens after entering say 20 or more lines.


--

Dave Peterson
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
Format Issue DS Excel Worksheet Functions 4 October 13th 06 01:20 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 09:17 PM
More than 3 conditional formats? Ltat42a Excel Discussion (Misc queries) 12 January 6th 06 12:26 PM


All times are GMT +1. The time now is 08:19 PM.

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"