Edit a Formula Using the Formula Bar : Formula Bar « Formula « Microsoft Office Excel 2007 Tutorial






Select the cell that contains the formula. 
           Press F2 key to change to Edit mode.
Select the cell that contains the formula. Press F2 key to change to Edit mode.
Do the editing. 
           Click the Enter button on the formula bar or Press Enter to comfirm.
Click the Enter button on the formula bar or Press Enter to comfirm.








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