Search

How to open Excel Insert Function dialog box

There are so many in-built functions in Excel, so that sometimes it may confuse the user to select the function by just typing-in the function name is Excel. Excel insert function dialog box is can be used to find the exact equation you need and the correct arguments required for that function.

Excel insert function dialog box can be opened from the Formulas tab in Excel Ribbon. Alternatively, you may use the shortcut key combination Shift + F3 also to open Excel insert function dialog box.

Refer following image to where to locate the button to open Excel insert function dialog box.

how open excel insert function dialog box

By-default most recently used functions are shown in the functions list. You may select a function category also, to select the function. Following image shows Excel insert function dialog box.

excel insert function dialog box

Written by Jajish Thomas.
Last updated on 27th January, 2022.

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel
Difference between Excel formulas and functions
What are Excel Function arguments
How to open Excel Insert Function dialog box
Excel Function arguments dialog box