Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
When I wrap text, excel hides the text display | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) |