Some versions of Excel also limit the character functions to certain fonts.
If that’s the case, simply type in a number in front of the superscript after you create it. On some computers, you may need to create the superscript in an empty cell before you can use the keyboard shortcut. Hold down Alt or Option and type in the correct superscript or subscript shortcut on your computer’s number pad.Īlt + 0185 or Option + 0185 creates a superscripted 1.Īlt + 0178 or Option + 0178 creates a superscripted 2.Īlt + 0179 or Option + 0179 creates a superscripted 3. These also won’t work on all computers.Ģ. Unfortunately, there are only superscript character codes for the numerals 1, 2, and 3 and no character codes for subscripts. Microsoft has a list of all the character codes on its website. Characters in Excel are sets of keys that return various numbers, letters, and special characters. You’ll have to adjust it to fit your needs.Įxcel’s character function codes allow you to use keyboard shortcuts to easily add 1, 2, or 3 as superscripts to numbers. When you add an equation to your Excel sheet, it won’t appear in a particular cell. The tool bar also gives you options to add things like fractions, exponents, and functions to your equations. For example, it has a symbols group with mathematical signs you can use in your equations, like ±, ÷, and many others. The toolbar contains several options for customizing your equations. The Equation tab and toolbar will only be visible while the equation on your worksheet is selected. Underneath the new tab, you’ll find the Equation toolbar. When you create your own equation or add an equation to your workbook, it’ll appear in the middle of your worksheet as a floating data point (not in a cell).Ī new tab called Equation will also appear in your Excel ribbon and be automatically selected. You can also design your own equation by pressing the ? icon above Equations. If you click the downward arrow next to Equation, you’ll see a list of prepared equations for you to use, like the Area of a Circle equation and the Pythagorean Theorem.Press the downward arrow next to Symbols at the top-right of your Excel workbook.Keep in mind that equations in the program can’t return results and will appear as floating data on your spreadsheet. The equations dialogue box includes equations like the formula for the area of a circle, the Pythagorean theorem, and the binomial theorem. Subscript and superscript in equationsĮxcel has several prewritten equations you can add to your spreadsheet with superscripts and subscripts already included. Subscript and superscript with custom formatġ.Subscript and superscript with a formula.Subscript and superscript with a keyboard shortcut.The four main ways to superscript and subscript to numbers in Excel are: We’ll introduce you to remote workers from all over the world who can help your company reach its potential. If you’re looking for Excel experts for your team, explore what Upwork can do for you. If you’re still unsure when to apply superscripts or subscripts, a Microsoft Excel expert can easily help you out. This means that water has two hydrogen atoms and one oxygen. For example, the chemical formula for water is H2O. Chemical formulas: Chemists describe compounds with subscripts.For example, if you have a registered trademark on your product, you’d write it like this: (product)®. Trademark symbols: You can use superscripts to identify intellectual property.The third listed on the page will look something like this: (information)3. For example, let’s say you cite several sources as footnotes. Footnotes: If you’re an author, you might use a superscript to point readers toward information in a footnote or endnote.You might have to show which car came in 1st, 2nd, and 3rd. Let’s say you’re sharing the results of an auto race. Number order: You could use a superscript to write down a sequence of instructions, events, or results.For example, 3 to the third power (3 x 3 x 3) would be written as 33. Mathematical concepts: One of the most common uses of a superscript in mathematics is when you’re representing a number to a certain power.Here are some situations where a superscript or subscript might come in handy: Subscripts and superscripts make things like mathematical equations and registered trademarks easily recognizable to whoever you share your spreadsheet with. Using subscripts and superscripts in your Excel sheets can improve the clarity of the information in them. Subscripts are less common than superscripts. A superscript is typed above the baseline of the word or number it’s attached to, while a subscript is typed below the baseline. Superscripts and subscripts are tiny letters or numbers attached to another word or number. What are superscripts and subscripts in Excel?