Using AutoComplete
AutoComplete is an Excel feature that helps you save time. You can begin typing the name of a function that you want to use in a cell. Excel displays a list of functions that start with those letters. Then you can simply select the appropriate function from the drop down list. This helps save time for the functions you use frequently. It also helps ensure accuracy for your arguments in the function.
Use the following procedure to use the AutoComplete feature.
Begin typing the SUM function. As soon as you type the Equals sign and the letter S, Excel displays a possible list of matching functions.
To select the SUM Function from the list, double-click on the SUM function.
Excel enters the function, but you must still enter the arguments. You can simply click on multiple cells, or click and drag to select a cell range. You can also type in the cell references.
Enter the final parenthesis mark to end the function.
- Press ENTER to enter the function in the cell.