When you have text in an Excel cell that is too long to be shown in the visible area of that cell, and the next cell on the right is empty, Excel lets the text be displayed in that next cell (and the next, and the next, as needed). I want to change this; 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.)