The font dialog box found in the main ribbon gives you the most options and is more reliable. ConclusionĪs you can see, there are a variety of different ways to create small numbers in Excel. On the open window, find the superscript and subscript icons.
If you don't like the hustle of going through all these steps of using the Format Cells dialogue box, you can directly pin both the superscript and subscript in the Quick Access Toolbar.Ĭlick on the downward arrow beside the redo icon and select 'More Commands' from the drop-down list. Under Effects, check the Superscript or Subscript box, depending on which one you want to apply. Click the Font Settings dialog box launcher.ģ. In Word, the common methods of typing/subscripting are as follows: The most important of these are the two formulas: Superscript: ctrl+shift + Three keys are. Select the numbers in a cell or cell range that you would like to make small numbers.Ģ. You can make small numbers in Excel outside the mathematical equations tolls through the Format Cells dialog box. Fill out the boxes with an appropriate number, then click OK. Click 'Script' from the 'Structures' group and select either superscript or subscript.Ĥ. Click on the 'Symbols' group and select the 'Equation' icon.ģ. Click the Insert tab in the main ribbon menu options.Ģ. You can achieve this through the Insert Equation method. To enter a small number to a number value can be tricky but manageable. Making a small number using the equation method Step 3: Place cursor in the document where you want to create a subscript. It means you cannot use the results for any calculations. Step 2: Enter the text that you want to insert. Remember, these keyboard shortcuts cannot be applied to numbers as this would convert numbers to strings. Next, press Alt + E to tick the Superscript checkbox. On your keyboard, press Ctrl + 1or Ctrl + Shift + F, which will open the Format Cells dialog box.ģ. Select the text or number you want to superscript on your worksheet.Ģ. When done, press the enter button and write the number you want to appear as a subscriptġ. Press Alt + B for the Subscript checkboxĤ. Just change the numbers within the CHARs to get corresponding subscript or superscript numbers with the joined alphabets H and O in Google Sheets. On your keyboard, press Ctrl + 1 or Ctrl + Shift + F for the Format Cells dialog box.ģ. Select your text by double-clicking on the cell or press F2 to enter edit mode.'Ģ. Make sure that you highlight the character(s) Use.
#How to make a superscript in excel how to
It is achieved through a combination of keyboard shortcuts. How to use the Subscript Shortcut Select one or more characters that you want to apply the subscript format.
#How to make a superscript in excel mac
You can easily make small numbers in your Excel worksheet through your PC's or Mac keyboard. Making a small number using the equation method.Making a small number in Excel using keyboard shortcuts.