Microsoft Excel is a convenient application that lives up to its reputation. Thanks to Excel‘s tools and functions, we can perform a seemingly unlimited variety of operations on a dataset. Exponents may be shown in Excel in several different ways, and this post will cover six of the more common and easy methods. As a result, you should use any of these 6 Simple Methods to Display Exponents in Excel.
Download Practice Workbook
Please receive a free copy of the example workbook utilized during the session.
6 Simple Methods to Display Exponents in Excel
To demonstrate, let’s use a sample dataset. The following dataset has columns labeled Number, Power, and Exponents for illustration purposes. To Display Exponents in Excel, we will go through each of the six approaches. The values of the number column will serve as the base value, while the value of the power column will serve as the exponent. The Exponent indicates how many times a value is multiplied on its own. The Power denotes the continuous multiplication of the same integer or factor. In phase 23, for instance, 3 is the exponent. Thus 23 is referred to as 2 to the power 3. We imply that 2 is multiplied by itself 3 times. In addition, I have yet to mention that I have used the Microsoft Excel 365 edition for this essay. You can use any version that gives you the most significant utilization.
1. Demonstrate Exponents Employing Custom Format in Excel
Custom Format in Excel alters only the visual representation of numbers inside a cell. The value contained in a cell’s underlying location is not changed. When modifying an Excel default format, the form is duplicated. It is not possible to alter or erase the original number format. In this section, we will use Custom Format to show Exponents. To do the task well, follow the steps below.
- First, copy the range of B5:B10 and paste it into the field D5:D10.
- Next, select Cell D5.
- Then, right-click on cell D5.
- After that, choose Format Cells.
- Subsequently, the Format Cells window will open up.
- At this time, select Custom and type 0 in the Type Box.
- Now, hold Alt, then type 0179.
- After that, release Alt later hit OK.
- As a result, we will get the output below.
- Similarly, repeat the same procedure in other cells.
- It is important to note that 3 and 2 can be exponents if Alt+0179 and Alt+0178 are used in the Type Box.
- Finally, it will show the outcome in the format below.
2. Display Exponents Using Equation Option
Excel is used to calculate and present data, but it is occasionally required to display the underlying formulae. Excel, like Microsoft Word, allows you to enter elegantly formatted arithmetic equations using the Equation editor. In this context, we shall demonstrate exponents using the Equation Option. Follow the instructions below to complete the assignment.
- First, go to the Insert tab.
- After that, click on Symbols, followed by Equation.
- Later, go to Script.
- Then choose the Left Box from the Subscripts and Superscripts.
- Subsequently, a tiny box will appear to take inputs.
- Next, type the base Number and the Power. In this case, 2 and 3, respectively.
- Then move the Box to Cell D5.
- Similarly, use the same procedure for other cells to achieve the below output.
3. Insert Excel CHAR Function to Demonstrate Power
This tutorial section will use an Excel formula to show exponents. For this instance, we’ll use the CHAR Function. However, using the CHAR Function, we can only show exponents between 1 and 3. To finish the work, follow the directions below.
- First of all, select Cell D5.
- Second, enter the following Formula in D5 to display 3 as an exponent.
- After that, press Enter key.
- As seen below, it will eventually provide the desired result.
- Now, pick cell D6.
- Next, enter the following formula into the cell.
- It is essential to note that we must use CHAR(185) and CHAR(178) for the exponents 1 and 2, respectively.
- Then, press the Tab or Enter key to see the intended outcome.
- Like previously, choose cell D7 and input the formula below.
- Later, hit Enter to find the demonstration below.
- Similarly, use the same procedure for other cells.
- In the end, the result will look like the portrait below.
4. Display Power with Keyboard Shortcut
Using Keyboard shortcuts to show Exponents in Excel is quite effective. In this instance, we must hold the Alt key down for a while. Please follow the instructions listed below to complete the task.
- First, copy the range B5:B10 and paste it into the D5:D10 content.
- Then, pick Cell E5.
- Second, double-click to enter edit mode.
- Next, hold the Alt key and write 0179.
- After that, release the Alt.
- Eventually, as shown below, it will provide the desired outcome.
- Likewise, perform the same method in other cells.
- It is important to remember that Alt+0179 and Alt+0178 must be used for 3 and 2 to be exponent, respectively.
- Finally, the result will appear as seen below.
5. Implement Superscript Command to Show Exponents in Excel
The Superscript feature in Excel is used to put numbers or text in tiny fonts just above more significant numbers and text. This section will set up exponents using the Superscript Format Command. Please follow the steps below to complete the task correctly.
- Firstly, write the values of cells B5 and C5 next to each other in cell D5. In this case, input 23.
- Apply the same procedure to all other cells. As a result, we will find the outcome below.
- Now, select the range D5:D10.
- Next, go to the Home tab, followed by Number Format.
- After that, type Text into the Box, then hit Enter.
- Again, double-click Cell D5.
- Then, carefully select only the Power. In this case, 3.
- Presently, right-click in the marked area.
- Afterwards, choose Format Cells.
- Subsequently, the Format Cells window will appear.
- At this time, check Superscript.
- Then, hit OK, followed by the Tab or Enter.
- Consequently, it will provide the intended outcome.
- Similarly, implement the same procedure in other cells to get the final output.
6. Display Exponents Through Excel VBA
Through the use of VBA in Excel, we can show exponents. Please follow the rules listed below to complete the assignment in the most time-effective manner.
- To begin, choose the active sheet of the worksheet.
- Secondly, navigate to Developer.
- Next, choose Visual Basic.
- Afterwards, click Insert, followed by Module.
- Now, paste the code below into the Module Box.
Sub show3AsExp() Selection.NumberFormat = "0" & Chr(179) End Sub Sub show2AsExp() Selection.NumberFormat = "0" & Chr(178) End Sub Sub show1AsExp() Selection.NumberFormat = "0" & Chr(185) End Sub
- Later, select the Save icon.
- After that, copy the range B5:B10 and put it in the field D5:D10.
- Presently, pick cell D5.
- Then, go to the View tab, followed by the Macros command.
- Subsequently, the Macros window will pop out.
- Later on, choose show3AsExp, followed by Run.
- Consequently, as shown below, it will produce the desired outcome.
- Likewise, apply the same method in other cells.
- It is essential to choose show2AsExp and show1AsExp for 2 and 1 to be exponent, respectively.
- Finally, we will find the output as shown below.
Read More: How to Use Excel EXP Function (5 Examples)
You may now Display Exponents in Excel by following the procedures we just covered. On the ExcelDemy Website, there are other articles similar to this one. Continue utilizing them, and let us know if you have additional methods or fresh ideas for completing the task. Please leave any questions, remarks, or recommendations in the space below.