Subscript in Excel (Shortcut)

Some Excel users have a need to show the subscript in some cells.

For example, if you want to write H2O in Excel, where you want the 2 to be below the H and the O, you will have to format it as a subscript.

example of subscript in Excel

While there is no option in the Excel ribbon to do this, you can still do this by going to the Format Cells dialog box. And you can also use a keyboard shortcut.

In this tutorial, I will give you the shortcut to apply a subscript format in Excel.

Shortcut to Subscript in Excel

Adding a subscript in Excel is a two-step step process:

First, you need to open the Format Cells dialog Box (which can be done with the below shortcut):

Control + 1 

And then, you need to select the Subscript option (once you’re in the Font tab). This can be done using the below shortcut.

ALT + B + Enter

How to Use the Keyboard Shortcut to Subscript in Excel

Below are the steps to use the above keyboard shortcut:

  1. Select the cell on which you want to apply the subscript format
  2. Use the keyboard shortcut Control + 1 (hold the control key and then press the 1 key)
  3. In the Format Cells dialog box, select the Font tab
click the font tab
  1. Use the keyboard shortcut ALT + B + Enter (press in succession)

Important Things to Know About Subscript in Excel:

In most cases, you would be required to apply the Subscript format only to a portion of the text in a cell (rather than the entire cell)

To do this, place your cursor inside the cell and select the text on which you want to apply the subscript format, and then follow the steps above

Pro Tip: If you need to alley the subscript format quite often you can add the subscript icon in the quick access toolbar so that you can access it with a single click

Other Excel shortcuts you may also like:

Other Excel Tutorials You May Also Like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.