To adjust the height of the formula box with drag and drop : Formula Bar « Formula « Microsoft Office Excel 2007 Tutorial






Point to the bottom of the formula box until the pointer changes to a vertical double arrow. Drag up or down.
6.7.Formula Bar
6.7.1.Edit a Formula Using the Formula BarEdit 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 lineTo 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 cellAutomatically fit the formula box to the number of lines in the active cell