Exceljet

Quick, clean, and to the point

Open the Insert Function Dialog Box

Windows shortcut

ShiftF3

Mac shortcut

Fn⇧F3

This shortcut displays the Insert Function dialog box on Windows and the Formula Builder dialog box on a Mac.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

Shortcuts for named ranges

In this lesson, we cover shortcuts you can use to create, list, edit, and apply named ranges.

How to enter functions

In this video, we'll look at several ways to to enter Excel functions.

Shortcuts for functions

In this lesson, we cover shortcuts you can use when working with Excel's functions.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

Thanks for this site. It really is quick and to the point. Each article gives the information you need to solve the problem without excessive descriptions that you usually have to skim through. Keep up the great work! -Pernilla

Open the Insert Function Dialog Box

Related videos

Download 200+ Excel Shortcuts

Excel video training