Insert shortcut in Excel

• Release Jan 25, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

Excel provides a variety of shortcuts for insertion. rows, cut cells, comments, pivot tables, etc. can also be inserted using shortcut keys. There is also a shortcut to display the Insert Function dialog box, which I will introduce here. When you insert a function using the Insert Function dialog box, you can operate it while checking the arguments.

Insert Function dialog box shortcut

Windows
Shift + F3

Mac
shift + F3

Display the Insert Function dialog box on Windows

Use the shortcut keys to display the Insert Function dialog box and insert a function.

Total Time: 1 minute

Select a cell

Select the cell in which you want to enter the function. Press Shift + F3.

The Insert Function dialog box will appear

The Insert Function dialog box will appear. Enter the name of the function you want to search (ex COUNTA). Press Enter.

Function is found

The function was searched. Use ↓ (Down Arrow key) to select the function, and press Enter.

Set the argument

The Function Arguments dialog box will appear. Enter the argument (ex A2:A5). Press Enter.

The function has been inserted

The function has been inserted and the calculation has been done.

Display the Insert Function dialog box on Mac

Select the cell in which you want to enter the function.

Press shift + F3.

The Formula Builder will appear on the right side of the screen.

Enter the name of the function you want to search for (ex COUNTA) and press Enter.

Click to select the function you want to enter in the cell.

Enter the argument (ex A2:A5) and press Enter.

The function has been inserted and the calculation has been done.