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.
How to Type Exponential in Excel: 6 Easy Ways
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.
- 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.
2. Create Excel CHAR Formula for Printing Exponential
This method will use the CHAR function to display exponential in Excel. The Excel CHAR function returns a specific character when we input a code number. CHAR formula codes to display exponential are:
To type 1, type =CHAR(185)
For displaying exponential 2, type =CHAR(178)
To print exponential 3, type =CHAR(179)
Let’s try to implement this function with the procedures given below.
- 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
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.
- 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.
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.
- 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.
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 on the procedures.
- 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.
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:
- 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 then tap 0179, and release Alt.
- Thus, we get the exponentials in our dataset.
Download Practice Workbook
You can download this workbook to practice yourself.
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.
- How to Use Exponent Symbol in Excel
- How to Calculate Exponential in Excel
- How to Use Excel Exponential Function of Base 10
- Convert Scientific Notation to x10 to the Power of 3 in Excel
- How to Use Negative Exponents in Excel
- How to Estimate Inverse Exponential in Excel
- How to Make Exponent in Excel Text