Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Display Exponents in Excel (6 Simple Methods)

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.

how to display exponents in excel


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.

STEPS:

  • First, copy the range of B5:B10 and paste it into the field D5:D10.

Demonstrate Exponents Employing Custom Format in Excel

  • 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.

Demonstrate Exponents Employing Custom Format in Excel

  • 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.

Output of Demonstrating Exponents Employing Custom Format in Excel

Note: Applying this method, we cannot display the value of B9 with Exponent. In this case, (-7).

Read More: How to Use Negative Exponents in Excel (3 Easy Methods)


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.

STEPS:

  • First, go to the Insert tab.

Display Exponents Using Equation Option

  • After that, click on Symbols, followed by Equation.

  • Later, go to Script.
  • Then choose the Left Box from the Subscripts and Superscripts.

Display Exponents Using Equation Option

  • Subsequently, a tiny box will appear to take inputs.
  • Next, type the base Number and the Power. In this case, 2 and 3, respectively.

Display Exponents Using Equation Option

  • Then move the Box to Cell D5.

  • Similarly, use the same procedure for other cells to achieve the below output.

Output of Displaying Exponents Using Equation Option

Read More: How to Use Excel Exponential Function of Base 10 (6 Examples)


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.

STEPS:

  • First of all, select Cell D5.
  • Second, enter the following Formula in D5 to display 3 as an exponent.
=B5&CHAR(179)
  • After that, press Enter key.
  • As seen below, it will eventually provide the desired result.

Insert Excel CHAR Function to Demonstrate Power

  • Now, pick cell D6.
  • Next, enter the following formula into the cell.
=B6&CHAR(178)
  • 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.

Insert Excel CHAR Function to Demonstrate Power

  • Like previously, choose cell D7 and input the formula below.
=B7&CHAR(185)
  • 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.

Output of Inserting Excel CHAR Function to Demonstrate Power

Read More: How to Type Exponential in Excel (6 Easy Ways)


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.

STEPS:

  • First, copy the range B5:B10 and paste it into the D5:D10 content.

Display Power with Keyboard Shortcut

  • 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.

Display Power with Keyboard Shortcut

  • 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.

Output of Displaying Power with Keyboard Shortcut

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


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.

STEPS:

  • Firstly, write the values of cells B5 and C5 next to each other in cell D5. In this case, input 23.

Implement Superscript Command to Show Exponents in Excel

  • 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.

Implement Superscript Command to Show Exponents in Excel

  • 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.

Implement Superscript Command to Show Exponents in Excel

  • Consequently, it will provide the intended outcome.

  • Similarly, implement the same procedure in other cells to get the final output.

Output of Implementing Superscript Command to Show Exponents in Excel

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


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.

STEPS:

  • To begin, choose the active sheet of the worksheet.
  • Secondly, navigate to Developer.
  • Next, choose Visual Basic.

Display Exponents Through Excel VBA

  • 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.

Display Exponents Through Excel VBA

  • 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.

Display Exponents Through Excel VBA

  • 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.

Output of Displaying Exponents Through Excel VBA

Read More: How to Use Excel EXP Function (5 Examples)


Conclusion

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.


Related Articles

Lutfor Rahman Shimanto

Lutfor Rahman Shimanto

Hi there! I am Lutfor Rahman Shimanto. I have completed my graduation in Information Technology from Jahangirnagar University. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of work, I enjoy Chess a lot. I am a founding member of the Jahangirnagar University Chess Club and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo