When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?
Problem
In Excel 2010, or any other version probably, if I enter in a cell a long single-line text that is longer than the width of the cell, Excel sometimes render the text across the next adjacent cells; some other times, it gets cut off at the boundary with the adjacent cell to the right. I would like to know how does Excel decide what to do, so I can better control my layouts. Note that I do not want to use merge cells, as it is inappropriate at times. Also, I already tried "Clear All" formatting on all affected cells but it still doesn't seem to reveal much. Any ideas?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?
For text to overflow beyond the edge of a cell, the following conditions must be true: The cell does not have "Wrap Text" turned on The cell is not a merged cell The cell contains a value that exceeds the width of the cell The adjacent cell is empty* and not a merged cell The cell has any of the following horizontal alignments: General Left (Indent) Center Right (Indent) Center across selection (Right overlaps the cell to the left; center overlaps on both sides.) The cell contents are not rotat…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix