Insert Function In Excel

Article byJeevan A Y
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Excel Insert

Insert function is not an actual function in Excel. Instead, it is a
wizard box provided by Excel to help us find out the type of function
we require in our data. In older versions of Excel, this function was
located in the “Insert” tab. However, in the newer versions of Excel,
this wizard box is available in the “Formulas” tab by clicking on the
“fx” button, the wizard box for the Insert function.

Suppose you cannot find the right function for your dataset or Excel worksheet. In such a scenario, you can use the Excel Insert function. This function may allow us to search for the appropriate function that we want. Moreover, in the case of complex functions, it may even help by inserting the arguments.

For example, consider the data which needs multiplication. We can easily find the solution using Insert function in Excel.

Press the Enter button. We can see the solution as shown in the image below.

Likewise, we can use Insert function in Excel.

Key Takeaways

  • The Insert function is not an actual function in Excel. This function was previously available in the “Insert” tab of prior versions of Excel. In later versions of Excel, however, this wizard box is available in the “Formulas” tab by clicking on the “fx” button, the Insert function wizard box.
  • Using INSERT FUNCTION should only be used for our understanding. After becoming familiar with formulas, we can type them directly into the cell.
  • The ‘More Functions’ button allows you to insert a function under the Autosum drop-down. Pressing ‘Shift + F3’ is a quick way to insert a function in Excel.

How To Use Excel Insert Function?

Method #1 – Using Equal To Sign

We all know all the formulas in Excel, starting with an equal (=) sign. We think this is what our early Excel coach must have taught us. So now, let us begin by inserting the formula in Excel with an equal sign first.

You can download this Insert Function Excel Template here – Insert Function Excel Template
#1 – Calculations without Inbuilt Formulas

We can use Excel as a basic calculator to perform basic calculations without the help of inbuilt formulas. However, unlike a calculator, Excel can make the formula dynamic if we refer the formula to cells. On the other hand, if we are inserting the numbers directly into the formula, it does not make the formula dynamic.

  1. Now, look at the calculation of 10 + 20 = 30 in Excel. First, open the equal sign in cell A1.

    Insert Function 1

  2. Type 10+20.

    Insert Function 1-1

  3. Now, press the “Enter button.” It will perform the calculation just like a calculator.

    Insert Function 1-2

Now, we can see the result of 10+20 in cell A1. We can see the formula in the formula bar.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#2 – Calculations Without Inbuilt Formulas: Based On Cell Values

We have learned how to enter the formula in Excel by using equal and supply values directly to the formula itself. Now, we may see how to apply formulas for cells.

In cell A1, we have the number 10. In cell A2, we have the number 20. Finally, in cell A3, we want the summation value of these two.

Insert Function 2

So, first, we must open the equal sign in cell A3 and select the A1 cell.

Insert Function 2-1

After selecting cell A1, type the “plus (+)” sign and select cell A2.

Insert Function 2-2

Then, press the “Enter” key to see the Excel formula result.

Insert Function 2-3

It is a dynamic formula because if any change happens in cells A1 and A2, it will impact cell A3. After all, the A3 cell contains the formula completely dependent on A1 and A2 cells.

Method #2 – Using Insert Function Dialog Box

Example #1 – Excel Built-in Formulas

Take the same example as cells A1 and A2. We must apply the built-in SUM function to get the total. In A3, after an equal sign, type the letter S, and we will get all the formulas that begin with S.

Insert Function Example 1

Next, enter the letter U. Now, we will see all the formulas that start with SU.

Insert Function Example 1-1

Like this, we can apply built-in formulas in Excel. Of course, remembering 450+ formulas in Excel is not an easy task, but we can insert formulas by using the Excel INSERT FUNCTION option.

Insert Function Example 1-2

Click on this fx option to open the INSERT FUNCTION dialogue box.

Insert Function Example 1-3

Here we can search for the formula we want to use. If we are not sure which formula to apply, we can enter a brief description of the formula. For example, if we go to SUM cellsSUM CellsThe SUM function in excel adds the numerical values in a range of cells. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. The values supplied to the function can be numbers, cell references or more, we can write sum cells, giving us the list of excel formulasList Of Excel FormulasThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and more.

Insert Function Example 1-4

Once we get the recommended formulas, click on the function we want to use.

Insert Function Example 1-5

Now we need to specify which cells we want to use to SUM.

Insert Function Example 1-6
  • Number 1 will be our first number, which is there in the cell A1.
  • Number 2 will be our second number, which is there in the cell A2.

Select both the numbers.

Insert Function Example 1-7

Now, look at the options we have. It has opened up one more Number 3 slot to select the third number, if any. And also, we can see the resulting review here only.

Insert Function Example 1-8

Click on “OK” to complete the formula. We will have a result in the A3 cell.

Insert Function Example 1-9
Example #2 – Using Insert Function Dialog Box

Take a look at one more example. We have four values.

Example 2

In cell B6, we want to calculate the AVERAGE values of the above four numbers in cells B2, B3, B4, and B5.

Step 1: We must first select cell B6 and click on fx.

Example 2-1

Step 2: Now, we will see the INSERT FUNCTION dialog box.

Example 2-2

Step 3: Now, type AVERAGE in the search box and click on “GO.” We may see the AVERAGE function.

Example 2-3

Step 4: Then, select the AVERAGE function. We may see the dialog box.

Example 2-4

Step 5: Select the first two cell values, B2 and B3. It will open up another cell referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in more.

Example 2-5

Step 6: Like this, we must select all the values we want to find the average.

Example 2-6

We can now see the result preview and what cells we have chosen. Click on “OK” to complete the formula.

Example 2-7

We have the AVERAGE function in cell B6.

Important Things To Note

  • We must limit the INSERT FUNCTION only for our understanding. Once we are comfortable with formulas, type them directly into the cell.
  • We can also INSERT FUNCTION under the FORMULA tab.
  • We can INSERT FUNCTION under Autosum drop down by clicking on “More Functions.”
  • The shortcut key to INSERT FUNCTION in Excel is “Shift + F3.”

Frequently Asked Questions

1. How to disable Insert function in Excel?

To cancel the Use insert mode in Excel, open the Excel Options window, click Advanced, and then go to Editing options.

2. What key is Insert function in Excel?

Consider the data which needs addition. We can easily find the solution using Insert function in Excel.

Press the Enter button. We can see the solution as shown in the image below.

Likewise, we can use Insert function in Excel.

The key ‘Shift+F3’ opens the Insert Function dialog window. The key F4 recurs the previous command or action if possible.

3. How do I lock an insert function in Excel?

Press Ctrl + 1 to reopen the Format Cells dialog, select the Protection tab, and verify that the Locked checkbox is checked. When the user selects the ‘Locked’ option, they are unable to overwrite, delete, or change the contents of the cells.

Recommended Articles

This article is a guide to Insert Function in Excel. We discuss inserting formulas and functions in Excel using the equal to sign and Insert function dialog box, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –