![]() ![]() In the same vein as the superscript example, you can use the CHAR function to create the subscript. Position the cursor on the text where you want to insert a symbol as a subscript. The method of writing them is the same as inserting symbols in a Google document. Method 2: Subscript in Google Sheets Using the CHAR functionĬonsider the chemical makeup of water: two hydrogen atoms and one oxygen atom, written H₂O. Subscripts and superscripts are also special characters in Google Docs. Here are the subscript characters: Character For Subscripts Press Ctrl +, on Windows. Step 2: Select the text to turn into a subscript. Step 1: Go to and open the document you want to edit. Search Graphemica and copy-paste the subscript into your Google Sheet, for example subscript two. To insert a superscript or subscript font in Google Docs using keyboard shortcuts: For Superscripts Press Ctrl +. How to Create Google Docs Subscript Text The steps in this guide were done in Google Chrome on a laptop but will work in most other desktop or laptop Web browsers. (Quick aside: You can use the CHAR function embedded in other formulas, like any other function.įor instance, here’s how to use the CHAR function to Create Custom Table Headers in Google Sheets Using Text Rotation.) Subscript In Google SheetsĪdd subscripts in the same way you added superscripts to your Google Sheets. You came here to learn how to add a superscript not a turkey.īack on the superscript two Graphemica page (see Method 1 above), copy the number part of the HTML Entity (Decimal), shown in red: Open an existing or new document to which you want to add the subscript. It lets you add weird and wonderful pictures to your Google Sheets using formulas, such as this Christmas tree (from my newsletter) or this turkey:Īnyway, I’m getting carried away. The CHAR function converts a number into a character according to the current Unicode table. Method 2: Create Superscripts in Google Sheets with the CHAR function Here’s a list of superscripts, which you can copy: Character To get multiple superscripts next to each other, just copy them multiple times e.g.Paste into your Google Sheet in the formula bar.Type in the symbol you want, using words instead of numbers e.g.Go to the website Graphemica, which is a great site to search for unicode characters.Open it and make your own copy from the menu: File > Make a copy Superscript In Google SheetsĪt the moment there is no built-in option to add a superscript in Google Sheets (or subscript), so we have to be creative to achieve the effect. Superscript And Subscript Google Sheets TemplateĪll of the superscript and subscript characters and CHAR function equivalents are available in this free template: In this tutorial, you’ll learn how to add a subscript or superscript in Google Sheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |