This article was written by Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 5,298 times.
This wikiHow teaches you how to create superscript characters in Excel using the font format tool and equations on Windows or macOS.
Steps
Method 1
Method 1 of 2:Using the Font Format Tool
-
1Open your project in Excel. You can either start a new project or open a saved one. To open a saved project, you can click File > Open in Excel or you can right-click the file and click Open with > Excel in your file manager (Finder for Mac, File Explorer for Windows).
- Use this method if you have text already written and want to format specific characters.
-
2Select the characters you want to format. You can select characters in a single cell, or you can select an entire cell range.Advertisement
-
3Click Home (if you aren't already in that tab). The "Home" tab should be open by default, but if not, click it to open it.
-
4Click the Font Settings dialog box launcher. This looks like a tiny arrow pointing out of a square that you'll see in the bottom right corner of the "Font" group.
- You can also press CTRL + 1 (Windows) or CMD + 1 (Mac).[1]
-
5Click to check the box next to "Superscript." You'll see this under the header "Effects."
-
6Click OK. Once you click this, all your selected text will change to reflect your selection.Advertisement
Method 2
Method 2 of 2:Using Equation Tools
-
1Open your project in Excel. You can either start a new project or open a saved one. To open a saved project, you can click File > Open in Excel or you can right-click the file and click Open with > Excel in your file manager (Finder for Mac, File Explorer for Windows).
- Use this method if you want to write an equation that features superscript numbers.
-
2Click Insert. You'll see this in the menu that runs horizontally across the top of your editing space next to Home.
-
3Click Equation. You'll see this in the Symbols group on the right side of your screen.
- If you aren't immediately redirected to the "Design" tab, click Design in the editing ribbon.[2]
-
4Click Script. A menu of equations will drop-down.
-
5Click to select an equation under "Superscripts and Subscripts." The equation with boxes will load on your spreadsheet.
-
6Click the squares and enter your numbers. You can also move the equation, as it isn't anchored to a specific cell.[3]Advertisement
References
- ↑ https://kb.nmsu.edu/page.php?id=74906
- ↑ https://support.microsoft.com/en-us/office/write-an-equation-or-formula-1d01cabc-ceb1-458d-bc70-7f9737722702#ID0EAACAAA=Edit_equations
- ↑ https://support.microsoft.com/en-us/office/format-text-or-numbers-as-superscript-or-subscript-3649411b-adf4-483e-b0e8-7b844605da74#:~:text=Format%20text%20values%20as%20superscript%20or%20subscript&text=Select%20characters%20in%20a%20cell,Font%20Settings%20dialog%20box%20launcher.&text=Press%20CTRL%2B1.,Subscript%20box%2C%20and%20click%20OK.
About This Article
1. Open your project in Excel.
2. Select the characters you want to format.
3. Click the Home tab (if you aren't already in that tab).
4. Click the Font Settings dialog box launcher.
5. Click to check the box next to Superscript.
6. Click OK.
