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 demonstrate this shortcut.
In this video, we'll look at several ways to to enter Excel functions.
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.