Using the Font Format Tool
Open 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.
Select the characters you want to format. You can select characters in a single cell, or you can select an entire cell range.
Click 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.
Click 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).
Click to check the box next to "Superscript." You'll see this under the header "Effects."
Click OK. Once you click this, all your selected text will change to reflect your selection.
Using Equation Tools
Open 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.
Click Insert. You'll see this in the menu that runs horizontally across the top of your editing space next to Home.
Click 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.
Click Script. A menu of equations will drop-down.
Click to select an equation under "Superscripts and Subscripts." The equation with boxes will load on your spreadsheet.
Click the squares and enter your numbers. You can also move the equation, as it isn't anchored to a specific cell.
Comments
0 comment