This tutorial demonstrates how to use formula autocomplete in Excel and Google Sheets.
Use Formula AutoComplete
- Say you want to use the SUM Function, to sum values from cells B2:B7, in cell B8. Select cell B2, and type =SU. You get a list of functions starting with SU–.
Tip: You could also start typing the function (=SU) directly into a cell instead of the formula bar.
- Now navigate with the ↓ (down arrow) key until the SUM Function is highlighted. Then press TAB on your keyboard to autocomplete the function name.
- Now that you have the function, you can also see input parameters. Select the range of cells to add up (B2:B7), close the parentheses and press ENTER.
Finally, you have the complete function in cell B8.
Autocomplete Formula in Google Sheets
Follow the same steps to autocomplete formulas in Google Sheets.