Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

share|improve this question
1  
if it'll turn out not to be possible, you can use a space character to the empty cells... –  deathApril Nov 19 '12 at 16:45
    
quite interesting - I don't know of any other way than using WordWrap,Font-AutoSize or characters in the other cells. –  Jook Nov 19 '12 at 17:28
1  
You can truncate extra characters by selecting all cells, going to Data / Text to Columns and specifying a break after as many characters as can fit in a cell without wrapping/overflowing. Remember to skip the additional column created that holds the extra chars! –  Karan Nov 20 '12 at 17:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.