XL2010 Long text won't overlap cell boundry

Microsoft Excel 2010 - complete product...
November 21, 2011 at 08:01:16
Specs: Windows 7
XL 2010 Long text won't overlap cell boundry.

A 100 character text in any cell truncates at the right edge of the cell and will not display in the empty cells to the right in the same row.
Problem occurred suddenly suggesting I accidentlly mis-set a setting in this workbook.
Copied a long text from another workbook, where a 100 character text does show across adjacent vacant cells, to my problem workbook. Instantly column widths over 10 or more columns were reset narrower, and ALL truncated texts suddenly displayed in adjacent empty cells!! The original workbook, (I saved under a new name for my mods) does not truncate texts at the cell boundary.
Any ideas on what happened here would be appreciated, and especially how to reset if it occurrs again.

See More: XL2010 Long text wont overlap cell boundry

November 21, 2011 at 12:53:14
Try selecting the cell to the right of your text cell and hitting the Delete key.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

November 21, 2011 at 14:36:35
Thanks for the reply ... Tried that. Didn't work.

Thought I found a partial answer.:
On NEW workbook: A long text is not truncated at the cell boundry.
Format this long text containing cell by
CTRL+1, Alignment, Text Alignment Horizontal, Fill:
The cell truncates the text at the cell boundary.
reformat the cell as general, the truncation vanishes.

But this does not work on my problem work book.
No solutions yet....

Report •
Related Solutions

Ask Question