How to Use Formula AutoComplete in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on September 6, 2023

This tutorial demonstrates how to use formula autocomplete in Excel and Google Sheets.

use formula autocomplete 1

Use Formula AutoComplete

When inserting formula in Excel, you can type the first few letters of the function in the formula bar and use the suggestion to autocomplete the formula.

  1. 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.

use formula autocomplete 1

  1. Now navigate with the ↓ (down arrow) key until the SUM Function is highlighted. Then press TAB on your keyboard to autocomplete the function name.

use formula autocomplete 2

  1. 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.

use formula autocomplete 3

Finally, you have the complete function in cell B8.

use formula autocomplete 4

Autocomplete Formula in Google Sheets

Follow the same steps to autocomplete formulas in Google Sheets.

completeformulas gs

AI Formula Generator

Try for Free

See all How-To Articles