To switch between expanding the formula box to three or more lines or collapsing it to one line : Formula Bar « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Formula Bar
Click the double-down arrow at the end of the formula bar
Click the double-down arrow at the end of the formula bar
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