How to use superscripts in Excel

How to apply superscript to text in Excel

The method you will use to apply superscript in Excel will differ depending on whether you are applying it to cells that contain text or numbers. If you want to apply superscript to text, you can do it using Cell Format.

To apply superscript to text in Excel:

1. Select the cell that contains your text.
   
2. In the formula bar, highlight only the letters or numbers you want to appear in superscript.
   
3. Right-click on your selection and select Format Cells.
   
4. Select the marked checkbox and click OK.
   
5. Your text will now be superscripted.
   

How to add a superscript button in Excel

If you want to add a lot of superscript text in Excel, you can add superscript in the ribbon button to speed up the process. This allows you to convert text to superscript with just one click.

To add a Superscript button to Excel:

1. Right-click anywhere in the Ribbon.
   
2. Select Customize Ribbon.
   
3. Click New Group.
   
4. Click to rename .
   
5. Give the new group a name of your choice and click OK.
   
6. Click the superscript at the bottom of the command list.
   
7. Click the Add button to add the superscript to your group, then click OK.
   
8. Your button will now appear in the ribbon.
   
9. To add a superscript to text, highlight the letter or number you want to appear in superscript and click the New button.

How to apply superscript to numbers in Excel

The above method will not work if you are working with numbers or equations in Excel. When you click outside the cell, the number returns to its standard format. However, you can apply superscript to numbers in Excel in several ways.

Using Equations

You can insert equations into Excel and take advantage of a number of preset math layouts. This includes the option to write one value as a superscript of another value. You can create equations in Excel in several ways.

The easiest way is to use the Equation Editor, which allows you to create equations in a format of your choice. By using the superscript format, you can quickly create superscript.

Insert formulas in Excel:

1. Click Insert menu.
   
2. In the Symbols group, click Equations.
   
3. In the Structure section, click Script.
   
4. Click on the mark format.
   
5. In your equation, click on each small box in turn and add your values.
   
6. Click anywhere else in the spreadsheet to see the completed equation.
   

How to Use Ink Equations in Excel

Another option is to use the Ink Equations feature when you create more complex This feature is particularly useful when working with equations. This feature allows you to write an equation using your cursor, and Excel will convert it to text.

Create a superscript using Ink Equation:

1. Select the Insert menu.
   
2. In the Symbols section, click Equations.
   
3. In the ribbon, select Ink Equation.
   
4. Write your equation using the cursor.
   
5. If the preview doesn't go as you expected, click the "Erase" button to delete any poorly written parts and rewrite them again.
   
6. When the preview matches the equation you want, click Insert.
7. Your equation will now appear in your spreadsheet.
   

How to insert superscript numbers using character codes in Excel

If the superscript value you want to insert is 1, 2 or 3, then there is Another quick way to add superscript to numbers. You can use character codes to insert these characters by pressing a set of key combinations.

You will need a keyboard with a numeric keypad as this only works with numeric keypad keys and not the number keys on the top row of the keyboard. If your keyboard doesn't have a number pad, you can use the on-screen keyboard instead.

Add a superscript using the character code:

1. Type the desired value at the bottom of the superscript.
2. Now hold Alt and press 0, 1, 8, 5 to get superscript 1.
   
3. For superscript 2, hold Alt and press 0, 1, 7, 8.
   
4. If you want to insert a superscript 3, hold down Alt and press 0, 1, 7, 9.
   

How to insert superscript numbers using formulas

You can also use these same codes to insert superscripts through formulas. Excel converts your formula to a superscript value by inserting it with the relevant character code.

To insert a superscript using the formula:

1. Click the cell where you want to display superscript.
2. To insert a power of 1, type =3&CHAR(185). You can change "3" to any value you wish.
   
3. To insert a power of 2, type =3&CHAR(178).
4. To insert a power of 3, type =3&CHAR(179).
5. Press Enter.
6. Your superscript will appear.
   

Mastering Excel

Learning how to use superscripts in Excel allows you to use more than just standard values. You can now use Excel with equations, or simply display measurement units correctly. There are many other ways to open up more functionality in Excel.

The above is the detailed content of How to use superscripts in Excel. For more information, please follow other related articles on the PHP Chinese website!