Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Text extending beyond the right and bottom border of cell

Hello,

I have a great deal of text within a cell (several paragraphs). The text is
extending beyond the right and bottom borders of the cell, despite the fact
that I have "Wrap Text" checked in Format Cells. Changing the size of the
text isn't really an option, as this is for an important investigative
document.

Could anyone please advise a solution?

Thank you for your time.



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default Text extending beyond the right and bottom border of cell

If there is nothing to the right or bottom, your words will "leak"into them,
try putting a space in each of those cells and see if it resolves your
problem.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"LTeeple" wrote in message
...
Hello,

I have a great deal of text within a cell (several paragraphs). The text
is
extending beyond the right and bottom borders of the cell, despite the
fact
that I have "Wrap Text" checked in Format Cells. Changing the size of the
text isn't really an option, as this is for an important investigative
document.

Could anyone please advise a solution?

Thank you for your time.





  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default Text extending beyond the right and bottom border of cell

XL only displays about 1,000 characters in a cell:
http://office.microsoft.com/en-us/ex...992911033.aspx

There is no workaround.

Dave
--
Brevity is the soul of wit.


"LTeeple" wrote:

Hello,

I have a great deal of text within a cell (several paragraphs). The text is
extending beyond the right and bottom borders of the cell, despite the fact
that I have "Wrap Text" checked in Format Cells. Changing the size of the
text isn't really an option, as this is for an important investigative
document.

Could anyone please advise a solution?

Thank you for your time.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Text extending beyond the right and bottom border of cell

Thank you for the quick replies, John and Dave.

I appreciate it.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Text extending beyond the right and bottom border of cell

You sure you have wrap text turned on. I've never seen excel fill the cell to
the right when that formatting option was turned on.

And I've never seen excel fill the cell below either--no matter the format.

But I can see more than the 1000 (or so) characters that are in a cell by adding
alt-enters (to force new lines within the cell) every 80-100 characters.



LTeeple wrote:

Hello,

I have a great deal of text within a cell (several paragraphs). The text is
extending beyond the right and bottom borders of the cell, despite the fact
that I have "Wrap Text" checked in Format Cells. Changing the size of the
text isn't really an option, as this is for an important investigative
document.

Could anyone please advise a solution?

Thank you for your time.


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Text extending beyond the right and bottom border of cell

Alt&Enter is fine unless the appearance of the text needs to be OK both on
screen and when printed (forced breaks using Alt&Enter can appear in the
'wrong' place when the sheet is peinted). If this is the case, copy your text
into a text box, and drag the borders of the text box to exactly the same
width and height as your merged cells. You can use format text box to remove
the border if required.
--
Bertie C


"Dave Peterson" wrote:

You sure you have wrap text turned on. I've never seen excel fill the cell to
the right when that formatting option was turned on.

And I've never seen excel fill the cell below either--no matter the format.

But I can see more than the 1000 (or so) characters that are in a cell by adding
alt-enters (to force new lines within the cell) every 80-100 characters.



LTeeple wrote:

Hello,

I have a great deal of text within a cell (several paragraphs). The text is
extending beyond the right and bottom borders of the cell, despite the fact
that I have "Wrap Text" checked in Format Cells. Changing the size of the
text isn't really an option, as this is for an important investigative
document.

Could anyone please advise a solution?

Thank you for your time.


--

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



All times are GMT +1. The time now is 03:09 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"