Home > Common Problem > body text

How to use superscripts in Excel

王林
Release: 2023-04-30 19:16:13
forward
8103 people have browsed it

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.
    如何在 Excel 中使用上标
  2. In the formula bar, highlight only the letters or numbers you want to appear in superscript.
    如何在 Excel 中使用上标
  3. Right-click on your selection and select Format Cells.
    如何在 Excel 中使用上标
  4. Select the marked checkbox and click OK.
    如何在 Excel 中使用上标
  5. Your text will now be superscripted.
    如何在 Excel 中使用上标

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.
    如何在 Excel 中使用上标
  2. Select Customize Ribbon.
    如何在 Excel 中使用上标
  3. Click New Group.
    如何在 Excel 中使用上标
  4. Click to rename .
    如何在 Excel 中使用上标
  5. Give the new group a name of your choice and click OK.
    如何在 Excel 中使用上标
  6. Click the superscript at the bottom of the command list.
    如何在 Excel 中使用上标
  7. Click the Add button to add the superscript to your group, then click OK.
    如何在 Excel 中使用上标
  8. Your button will now appear in the ribbon.
    如何在 Excel 中使用上标
  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.
    如何在 Excel 中使用上标
  2. In the Symbols group, click Equations.
    如何在 Excel 中使用上标
  3. In the Structure section, click Script.
    如何在 Excel 中使用上标
  4. Click on the mark format.
    如何在 Excel 中使用上标
  5. In your equation, click on each small box in turn and add your values.
    如何在 Excel 中使用上标
  6. Click anywhere else in the spreadsheet to see the completed equation.
    如何在 Excel 中使用上标

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.
    如何在 Excel 中使用上标
  2. In the Symbols section, click Equations.
    如何在 Excel 中使用上标
  3. In the ribbon, select Ink Equation.
    如何在 Excel 中使用上标
  4. Write your equation using the cursor.
    如何在 Excel 中使用上标
  5. If the preview doesn't go as you expected, click the "Erase" button to delete any poorly written parts and rewrite them again.
    如何在 Excel 中使用上标
  6. When the preview matches the equation you want, click Insert.
  7. Your equation will now appear in your spreadsheet.
    如何在 Excel 中使用上标

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.
    如何在 Excel 中使用上标
  3. For superscript 2, hold Alt and press 0, 1, 7, 8.
    如何在 Excel 中使用上标
  4. If you want to insert a superscript 3, hold down Alt and press 0, 1, 7, 9.
    如何在 Excel 中使用上标

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.
    如何在 Excel 中使用上标
  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.
    如何在 Excel 中使用上标

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!

source:yundongfang.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template