To understand this post, open a new workbook and enter a long text in cell 
B2, say 
This is a long sentence to understand the post Wrap text does not adjust row height in Excel 2007.
Now enter some text in cell 
C2, say 
123. You will see that the text in the cell 
B2 gets truncated. To see all the text that you typed, click cell 
B2 and click the 
Wrap Text command that is available in the 
Alignment group on the 
Home tab. You will see that the row height gets automatically adjusted to fit the text.
Now adjust the row height of 
row number 3 manually by dragging the bottom border of 
row header 3 to a height say 
36.00 which is 
48 pixels. After the row height is changed, click cell 
B3 and enter the text 
This is also a long sentence to understand the post Wrap text does not adjust row height in Excel 2007. Now you will see some text being truncated when some text is entered in cell 
C3. Click cell 
B3 and click the 
Wrap Text that is available in the 
Alignment group on the 
Home tab.
You will see that the row height has not changed, right. To adjust the row height, perform the following:
1.  Click on the cell or the row header.
2.  On the 
Home tab, in the 
Cells group click 
Format, and click 
Autofit Row Height.
 
0 comments:
Post a Comment