Enter Items in a Formula Using Formula AutoComplete : Formula AutoComplete « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Formula AutoComplete
Click A16. 
           Type '=su' to display all value items, such as SUBTOTAL and SUM. 
           As you type, a drop-down scrollable list of valid items is displayed.
Type '=su' to display all value items, such as SUBTOTAL and SUM. As you type, a drop-down scrollable list of valid items is displayed.
To insert the selected item into the formula, 
           press Tab or double-click the item.
To insert the selected item into the formula, press Tab or double-click the item.








6.6.Formula AutoComplete
6.6.1.Enter Items in a Formula Using Formula AutoCompleteEnter Items in a Formula Using Formula AutoComplete
6.6.2.Turn on Formula AutoCompleteTurn on Formula AutoComplete