Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default In Excel sometimes the end of the text does not wrap - why?

Issue being, merged cells into Excel spreadsheet. Some cells would wrap but
others would not. Tried changing the font - that didn't work. Tried
changing the column width - got to be too wide. The last 4 lines would not
wrap not matter what I did. Now I am considering re-typing the cell from
scratch or maybe there is something in the cell that I cannot see thus
causing a non-wrap. Please advise. Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default In Excel sometimes the end of the text does not wrap - why?

This is one of the limitations of using merged cells, which I try to avoid at
all costs. When using merged cells you'll have to force wordwrap by
inserting a new line within the cell. This is accomplished by pressing <Alt
+ <Enter to force a line break a the current cursor location.

You can do this after the fact as well. If you're anything like me typing
something once is more than enough and if retyping can be avoided I always
opt for that route.
--
Kevin Backmann


"zzzzzzzzz" wrote:

Issue being, merged cells into Excel spreadsheet. Some cells would wrap but
others would not. Tried changing the font - that didn't work. Tried
changing the column width - got to be too wide. The last 4 lines would not
wrap not matter what I did. Now I am considering re-typing the cell from
scratch or maybe there is something in the cell that I cannot see thus
causing a non-wrap. Please advise. Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default In Excel sometimes the end of the text does not wrap - why?

If the text just fades away, it's not really a wrapping problem. It's more of
display problem.

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

zzzzzzzzz wrote:

Issue being, merged cells into Excel spreadsheet. Some cells would wrap but
others would not. Tried changing the font - that didn't work. Tried
changing the column width - got to be too wide. The last 4 lines would not
wrap not matter what I did. Now I am considering re-typing the cell from
scratch or maybe there is something in the cell that I cannot see thus
causing a non-wrap. Please advise. Thanks.


--

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
How do I get date/time to wrap (format - wrap text doesn't work)? Alex Excel Discussion (Misc queries) 3 April 4th 23 02:29 PM
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
When I wrap text, excel hides the text display Vidyaji Excel Discussion (Misc queries) 4 March 12th 07 02:33 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
Some lines of text in Excel field do not wrap text. Please help. Michele Excel Discussion (Misc queries) 0 January 5th 06 07:27 PM


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