How Do I Add An Exponent In Excel

Calculation text and numbers to cells in Microsoft Excel is typically as easy as clicking on a cell and typing. Things become a little more than involved when you need to add a picture, or change the advent of the text that you've added, only it's still a very approachable task.

But things can start to get a little more difficult when y'all need to add some boosted types of information, such as an exponent. Fortunately, however, Excel does make it possible for you to include exponents in your data past post-obit the steps below.

How to Add an Exponent in Microsoft Excel for Office 365

The steps in this article were performed in the desktop version of Microsoft Excel for Office 365, but will also piece of work in nigh other desktop versions of Excel besides. The first part of this article is going to focus on displaying a value every bit an exponent in Excel without computing information technology. Subsequently that nosotros will show you how to use the POWER formula to perform a calculation involving an exponent.

Step i: Open your file in Excel.

Step 2: Click in the prison cell where you lot wish to add the exponent.

Step 3: Type the full text for the jail cell, then use your mouse to highlight the number that yous want to be an exponent.

Step four: Select the Dwelling house tab at the top of the window, then click the small Font Settings push button at the bottom-right corner of the Font section of the ribbon.

Footstep five: Check the box to the left of Superscript, so click the OK push button.

If you lot desire to perform a calculation involving an exponent, click within the cell where you wish to brandish the event, then type the formula:

=POWER (X, Y)

but replace 10 with the base number and y with the exponent. In the paradigm below I am determining the consequence of 8 to the 3rd power.

Does some of the text in your spreadsheet have formatting that is proving difficult to remove? Find out how to quickly clear all cell formatting in Excel and revert to the default formatting settings.

Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor's and Master's degree in Information science and has spent much of his professional person career in Information technology management.

He specializes in writing content about iPhones, Android devices, Microsoft Office and many other pop applications and devices.