How to Type Exponential in Excel (6 Easy Ways)

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, Excel provides some cool functions to write exponential in our workbooks. This article will show you 6 simple methods to type exponential in Excel.

Download Practice Workbook

You can download this workbook to practice yourself.

6 Easy Ways to Type Exponential in Excel

Typing exponential in Excel can be really cumbersome if we consider a large dataset. Alternatively, we can quickly write exponential with Excel tools and functions. Exponential is a mathematical term that we use in our various equations. With that in mind, in this article, I will show 6 easy methods to type exponential in Excel. For instance, we take a dataset that represents the compound interest rate of ABC bank.

1. Apply Superscript Command to Add Exponential

Excel provides some useful default text formats to modify our numbers into texts. To demonstrate this method, we will convert the data in our cell into text format. Afterward, we will add Superscript to implement the strategy. To do so, let’s follow the steps.

Steps:

• First, in the D column, type the base number 1.06 and their exponentials 1,2,3,4,5 side by side.
• See the below picture to better understand.

• Select the range D5:D9.
• After that, right-click on the selected range and go to Format Cells.

• Subsequently, the Format Cells dialogue box will pop up.
• Click Number > Text > Ok to format the range in text.

• Upon formatting in text, select the exponential text and right-click on it.
• Now, tap Format Cells.

• Eventually, the Format Cells dialogue box will open.
• Check the Superscript option and hit OK.

• As a result, the exponential appears in the dataset.

Read More: How to Make Exponent in Excel Text (7 Easy Methods)

2. Create Excel CHAR Formula for Printing Exponential

This method will use the Excel CHAR function to display exponential. Excel CHAR function returns a specific character when we input a code number. CHAR formula codes to display exponential are:

Let’s try to implement this function with the procedures given below.

Steps:

• In cell D5, type the CHAR formula to display exponential as 1,

• After that, press Enter.

• Similarly, in cell D6, type the formula to display exponential 2,

• Also, in D7, type the formula for exponential 3,

• Thus, we obtain our desired result.

Read More: How to Display Exponents in Excel (6 Simple Methods)

3. Press Keyboard Shortcuts to Apply Exponential

Using keyboard shortcuts is an easy way to add exponential to our dataset. Therefore, we will use keyboard shortcuts in this method. To do so, follow these steps.

Steps:

• Firstly, double-click on the cell to enter edit mode.
• Next, hold Alt and press the 0185 buttons.

• Later, release Alt to display the exponential 1.

• Similarly, for exponential 2,3 press the Alt + 0178 and Alt + 0179 keys respectively.
• Hence, we get the desired results.

Read More: Convert Scientific Notation to x10 to Power of 3 in Excel

4. Go to Equation Options to Display Exponential

In this method, we will print the exponential using Equation options under the Symbols group. Let’s follow the procedures.

Steps:

• First of all, go to Insert > Symbols.

• Next, tap the Equation button shown below.

• Afterward, click Script and then tap Superscript.

• As a result, a type option box will pop up.
• Here, input the base number and exponential as you wish.

• Lastly, we get our results.

Read More: How to Use Exponent Symbol in Excel (4 Easy Methods)

5. Embed Excel VBA to Add Exponential

Adding exponential is easy and time-saving if we implement it through Excel VBA code. We can write a simple code and run this to get our desired exponentials. Let’s follow up the procedures.

Steps:

• First, go to Developer > Visual Basic to open the Visual Basic window.
• After that, tap Insert and then Module to create a module.
• Now, in the module box, type the following VBA code:

Sub InputExpo3()
    Selection.NumberFormat = "0" & Chr(179)
End Sub
Sub InputExpo2()
    Selection.NumberFormat = "0" & Chr(178)
End Sub
Sub InputExpo1()
    Selection.NumberFormat = "0" & Chr(185)
End Sub

• Upon writing the code, close both windows.
• Later, go to View > Macros > View Macros.

• Eventually, the Macro dialogue box will pop up.
• To type exponential 1, select InputExpo1 and tap Run.

• Similarly, add exponential 2 & 3.
• Lastly, we get the desired result.

Read More: How to Calculate Exponential in Excel (3 Easy Methods)

6. Use Custom Formatting to Type Exponential in Excel

Excel provides some custom features to display exponential. Using a custom format and keyboard shortcuts, we can add exponential to our dataset. To illustrate, we will customize Format Cells to display exponential. Follow these steps:

Steps:

• First of all, right-click on D5.
• Later, select Format Cells as shown below.

• As a result, a Format Cells dialogue box will pop up.
• Next, click Number > Custom > Type.
• Now, write 00.0 in the Type box.
• Also, hold Alt and press 0185.
• Release Alt to add exponential 1 on the base.
• Lastly, hit OK.

• Similarly, to add exponential 2, type 00.0 in the Type box.
• Meantime, tap and hold Alt and press 0178.

• In the same way, for exponential 3, hold the Alt key and tap 0179 and release Alt.

• Thus, we get the exponentials in our dataset.

Read More: How to Estimate Inverse Exponential in Excel (3 Ideal Examples)

Conclusion

In conclusion, we have discussed some easy ways to type exponential in Excel. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please leave any further queries or recommendations in the comment box below.

Related Articles

• How to Use Negative Exponents in Excel (3 Easy Methods)
• Use Excel Exponential Function of Base 10 (6 Examples)
• How to Use Excel EXP Function (5 Examples)