This tutorial demonstrates how to use formula autocomplete in Excel and Google Sheets.
Use Formula AutoComplete
When inserting formula in Excel, you can type several first letters of the function in the formula bar, and use the suggestion to autocomplete the formula.
- Say that you want to use the SUM Function, to sum values from cells B2:B7, in cell B8. Select cell B2, and type =SU. You will get the list of functions starting with SU–.
Note: You can also start typing the function (=SU) in a cell, apart from the formula bar.
- Now navigate with arrows down, until the SUM Function is highlighted and, press TAB on your keyboard, in order to autocomplete the function name.
- Now you have the function, and you can also see input parameters. Select the range of cells to sum (B2:B7), close the bracket, and press ENTER.
Finally, you have the complete function in cell B8.
AutoComplete Formula in Google Sheets
Following exactly the same steps, you can autocomplete the formula in Google Sheets.