PC Review


Reply
Thread Tools Rate Thread

Cell wrap ceases after several lines?

 
 
spamlet
Guest
Posts: n/a
 
      21st Jun 2007
Any ideas why a combined cell crossing several columns should wrap text fine
for several lines, and then go off the side for the rest? The text is all
wrapped when actually editing within the 'cell', but when one leaves it only
the top few lines are wrapped and readable.

Cheers,

S


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      21st Jun 2007
You'll see this if the cell contains a longggggg string of text.

But you if you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll be able to see more.

spamlet wrote:
>
> Any ideas why a combined cell crossing several columns should wrap text fine
> for several lines, and then go off the side for the rest? The text is all
> wrapped when actually editing within the 'cell', but when one leaves it only
> the top few lines are wrapped and readable.
>
> Cheers,
>
> S


--

Dave Peterson
 
Reply With Quote
 
spamlet
Guest
Posts: n/a
 
      22nd Jun 2007
Thanks Dave,

I was using alt enters - and indeed thought this might be the problem until
I found I still had the phenomenon when I took them out again. Perhaps I am
not using them often enough. Anyhow, I expect the best thing to do is to
use a text box instead - though I have had problems with keeping them in the
right place in the past (esp when sorting). In this case it should not be a
problem as I only need one largish box.

Cheers,

S


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You'll see this if the cell contains a longggggg string of text.
>
> But you if you add alt-enters (to force new lines within the cell) every
> 80-100
> characters, you'll be able to see more.
>
> spamlet wrote:
>>
>> Any ideas why a combined cell crossing several columns should wrap text
>> fine
>> for several lines, and then go off the side for the rest? The text is
>> all
>> wrapped when actually editing within the 'cell', but when one leaves it
>> only
>> the top few lines are wrapped and readable.
>>
>> Cheers,
>>
>> S

>
> --
>
> Dave Peterson



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does Excel have a limit on lines it will wrap in a cell? =?Utf-8?B?Tm90dG1l?= Microsoft Excel Misc 4 5th Apr 2007 10:36 AM
Wrap text ceases to function in Excel if cell exceeds 9 lines =?Utf-8?B?bnljZW1haWw=?= Microsoft Excel Worksheet Functions 1 24th Jul 2005 06:09 PM
how many lines can be in wrap text within a cell? =?Utf-8?B?cGVhcnNtcw==?= Microsoft Excel Worksheet Functions 2 27th Dec 2004 06:11 PM
how many lines can be in wrap text within a cell? =?Utf-8?B?UGVhcg==?= Microsoft Excel Worksheet Functions 1 27th Dec 2004 11:35 AM
word wrap ceases after 1200 characters Jeff2004 Microsoft Excel Misc 3 23rd Jan 2004 12:13 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:00 AM.