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

**Table of Contents**hide

## 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 **2 ^{3}**, for instance,

**3**is the exponent. Thus

**2**is referred to as

^{3}**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.

**STEPS:**

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

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

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

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

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

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

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

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

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

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

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

- 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)**

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