Instead of going through the pain of searching, all you have to do is copy all the below symbols onto a google sheet somewhere (or a Google Doc) and then use them as and when needed.
To simplify everything, here are all the available superscript Unicode symbols in one place. There are some superscript symbols for uppercase letters as well. In addition to that, there are also various superscript symbols available for all lowercase letters (except the letter q for some reason). Unicode symbols are available for superscripts of every number from 0 to 9, a few Greek symbols as well as mathematical symbols like +, –, = and (). You can simply copy this value or symbol and paste it to your Google Sheet. This will give you the Unicode symbol for the number 6 in superscript form as shown below. On the other hand, there are some that like to head to to look up a superscript of choice by searching the word ‘superscript’, followed by the number you are looking for (in words).įor example, if you are looking for the superscript form of the number 6, you can type ‘Superscript six’ (or just type superscript and then select 6 from the list).
#HOW TO MAKE A SUPERSCRIPT ON EXCEL FULL#
Lucky for us, there is a full set of superscript Unicode symbols available, that can be easily Googled, copied and pasted when you want to. These symbols are a lot like emojis, but you can use them as part of your text if you want.Īll you need to do is copy and paste the symbol into your cell. The second and much easier method to incorporate superscripts in Google Sheets is by using Unicode Symbols. In the same way, there are numerical values corresponding to superscript numbers using values from 0 to 9, as well as mathematical symbols like (), +, – and =. What this means is that if you type the following CHAR function into a cell and press the Enter/Return key, you will get the letter ‘A’ as a result of the function. If you need an example, the decimal value for the character A is 67. This function gives the character value corresponding to a given decimal value.Ĭorresponding to each character, are numerical values (called ASCII codes). The CHAR() function is an in-built function within Google sheets. Lucky for you, there are ways to add superscripts in Google Sheets. And it’s kind of forgivable as Google Sheets was built to work with numbers and is not a word processor( ideal for superscribing)īut a lot of people do need to display data that comes in the form of fractions or formulae in spreadsheets too (this is also one of the common queries I get from people).
Using superscripts is fairly easy on Google Docs, but this feature has not yet been implemented on Google Sheets. It is also used to represent temperatures in degrees like for example, 1☌. Superscripts are often used to raise a number or variable to a certain power (eg: x3).
#HOW TO MAKE A SUPERSCRIPT ON EXCEL HOW TO#
Output: How to insert superscript (PC: Excelchat) How do you superscript in Google Sheets? In this case, we want to insert “3” as a superscript.įigure 6. Select the part of the text we want to format. If you know how to add subscripts, the process is the same as that, except you need to tick on the Superscript box under effects. How to insert superscript in text values? To Superscript text in Excel, use the following method. Sin2(30) – Here superscript is ‘2’ which is a number for its previous string ‘sin’.2nd – Here superscript is ‘nd’ which is a string for its previous number 2.ab – Here superscript is ‘b’ which is a character for its previous character a.X2 – Here the superscript is ‘2’ where the value is a number for its previous character X.And from there we can tick Superscript from Fonts tab. To activate this, go to edit mode of any cell and select Format Cells from the right-click menu. It is mainly made for Microsoft Word which deals with text. Likewise, we can superscript numbers as well such as 102 or 25. It is like using superscript to write the text in the square of base units or text such as Feet2, Meter2, etc. It is also used to represent temperatures in degrees like, for example, 3☌.Īs you can see it’s like we are giving a value or power raised to any base number as we do in mathematics (eg: x2). Superscript in excel is utilized to put the number or text in small fonts above the base numbers and text.