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. Start typing the first few letters of a function, then type Tab to accept the top option in the list that appears. You can also use up or down arrow keys to navigate the autocomplete list before pressing Tab.

Related videos

The videos below demonstrate this shortcut.
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 enter Excel functions.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.