Excel - Avoid cell text to be shown onto next empty cell
- by e-mre
When you have text in an Excel cell that is too long to be shown in the visible area of a single cell and the cell next to the first cell (the one on the right) is empty, Excel lets the text to be printed onto the next cell. This is what I want to change. I want to avoid this text overflow.
I know I can avoid this by enabling "word wrap" and adjusting row height. But that is not what I want.
I want to change the DEFAULT behavior of Excel so it shows the value of each cell only in the visible area of that cell. No overflow, no word wrap.
Is this possible? (I am using Excel 2010 by the way)
