Tuesday, 11 September 2012

Enter Items in a Formula Using 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.

No comments:

Post a Comment