Automatically fit the formula box to the number of lines in the active cell : Formula Bar « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Formula Bar

Point to the formula box until the pointer changes to a vertical double arrow. 
           Then double-click the vertical arrow.

6.7.Formula Bar
	6.7.1.	Edit a Formula Using the Formula Bar
	6.7.2.	To switch between expanding the formula box to three or more lines or collapsing it to one line
	6.7.3.	To adjust the height of the formula box with drag and drop
	6.7.4.	Automatically fit the formula box to the number of lines in the active cell