Excel Hack

Insert shortcut in Excel

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 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

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

Function is found

Function is found

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

Set the argument

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

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

Display the Insert Function dialog box on Mac

select a cell

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

Press shift + F3.

Select a function

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.

Set the argument

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

Mathematical expressions can be inserted

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


Articles related to Insert & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments