Exceljet

Quick, clean, and to the point

Accept function with autocomplete

Windows shortcut 
Tab
Mac shortcut 
Tab

This shortcut will accept a function suggested by autocomplete. On the PC, you can type Tab to enter the current "best match". On a Mac, you need to first use the down arrow key to select from the list of suggested functions, then press Tab to accept.

Related videos

The videos below show how this shortcut can be used.
In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.
In this lesson, we cover shortcuts you can use when working with Excel's functions.
In this video, we'll look at several ways to to enter Excel functions.