![how to do subscripts excel how to do subscripts excel](http://i.ytimg.com/vi/QX7zT7D9mxA/maxresdefault.jpg)
From here, you can use the accelerator keys to check the subscript or superscript options. There is a keyboard shortcut that will open the Format Cells menu with the Font tab active. Luckily the subscript or superscript format can be applied by combining two keyboard shortcuts in succession. The quickest way to perform any action in Excel is certainly by using a keyboard shortcut when it’s available. This can make mathematical equations and molecular formulas much easier to read! Add Subscript or Superscript with a Keyboard Shortcut Here you can see a few examples of the possible format output when combining subscript and superscripts to multiple parts of the text. Unfortunately, you will need to repeat these steps if you want to apply the format to multiple parts of your text as you can’t highlight multiple parts of your text while in edit mode. Once the Format Cells menu is open, go to the Font tab and check one of the Superscript or Subscript options. Right click and choose Format Cells from the menu options.Click on the Launch icon found in the Font section of the Home tab.Highlight the part of the text to format, then open the Format Cells menu with one of the following options. The good news is, it’s possible to apply the format to only part of a given text.Ĭlick into the formula bar or press the F2 key to enter edit mode on a cell that contains the text to partially format. These will only use scripts at certain places. Just think of a math equation or molecular formula. But it’s usually the case that you’ll only want a part of your text to have superscripts or subscripts.
#How to do subscripts excel how to
I just showed you how to apply the subscript or superscript format to the entire contents of a cell. Add Subscript or Superscript to Part of the Text Here you can see the results of applying the subscript or superscript format to a cell as compared to regular text. These formats are mutually exclusive for the same piece of text.
![how to do subscripts excel how to do subscripts excel](https://knowl365.com/wp-content/uploads/2021/01/select-text1.png)
Note: You can’t check both the subscript and superscript options at the same time. Go to the Font tab and check either of the Superscript or Subscript options to format your text.
![how to do subscripts excel how to do subscripts excel](https://websetnet.net/wp-content/uploads/2020/03/special-characters-superscript-1.png)
Go to the Home tab and click on the launch icon in the lower right corner of the Font section to open the Format Cells menu. Select any cell or range of cells that you want to apply the script format on. You can use either the subscript or superscript formats from the Format Cells menu. Unfortunately, the Subscript and Superscript options are missing from these frequently used format options. Add Subscript or Superscript from the Format Cells DialogĪ lot of common formatting commands can be found in the Home tab in the Font, Alignment, or Number section. This blog post will show you 11 easy ways to add subscripts and superscripts in Microsoft Excel.