Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Write Subscript in Excel (11 Easy Ways)

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, Excel provides some cool features to add subscripts to our workbooks. This article will show you 11 easy ways to Write a Subscript in Excel.


Download Practice Workbook

You can download this workbook to practice yourself.


11 Easy Ways to Write Subscript in Excel

We use subscripts to write different equations. For instance, we must add subscripts to write chemical equations. In this article, I will show you 11 easy ways to write subscripts in Excel. For instance, we take a dataset that represents the chemical components of coca-cola drinks.

how to write subscript in excel


1. Write Subscript Using Keyboard Shortcuts in Excel

Using keyboard shortcuts is the easiest way to add subscripts in Excel. Here, I have discussed some steps on how to add subscripts using keyboard shortcuts.

Steps:

  • First, select the text that you want to convert into a subscript.

Write Subscript Using Keyboard Shortcuts in Excel

  • Now, press Ctrl+Shift+F followed by Alt+B keys.
  • As a result, the selected text 3 in D5 is converted into a subscript.

  • Similarly, follow this procedure to the other texts.
  • Hence, you obtain your result.

Read More: How to Write CO2 in Excel (5 Easy Methods)


2. Insert Subscript from Quick Access Toolbar

We can customize the Quick Access Toolbar and directly add the Subscript button to it. Microsoft Excel 365, 2016, and later versions provide this option. Follow these procedures to add subscripts to your Excel documents.

Steps:

  • Firstly, tap the drop-down menu button at the end of the toolbar.
  • Subsequently, a drop-down menu will appear.
  • Afterward, select the More Commands option.

Insert Subscript from Quick Access Toolbar

  • Eventually, a context menu will pop up. Scroll down to find the Subscript option and select it.
  • Later, press Add and then Ok.

  • Thus, the Subscript option pops up in the Quick Access Toolbar.

Read More: [Solved:] Excel Subscript Not Working


3. Use Predefined Subscript Option in Excel Ribbon

Similarly, we can add a Subscript button in the ribbon bar in Excel. To do so, follow these steps.

Steps:

  • To demonstrate, right-click anywhere on Excel Ribbon.
  • Consequently, a context option menu will open.
  • Here, click Customize the Ribbon option.

Use Predefined Subscript Option in Excel Ribbon

  • Later, Select Subscript and create a New Group in the Insert tab.
  • Afterward, click Add and next hit Ok.

  • Therefore, a Subscript option button appears in the Insert tab.

Read More: How to Add Subscript in Excel Graph (7 Easy Methods)


4. Apply Equation Feature for Adding Subscript

The Equation feature in Excel helps to write different equations in our workbooks. In this method, we will use this tool to type subscripts in our sheets. Let’s see some procedures below.

Steps:

  • In the Insert tab, click the Equation button located under the Symbols group.

Apply Equation Feature for Adding Subscript

  • Eventually, an option will appear. Go to the Structure group.
  • Here, locate and select the Script option in the Design group.
  • Then, press the subscript format shown below.

  • Next, type your equation in the desired format.

How to write subscript in Excel output using equation feature


5. Write Subscript with Ink Equation

The Ink Equation is an interesting feature of Excel. In this tool, you can doodle your mouse to write your equations. Moreover, you can add subscripts in this way.

Steps:

  • Firstly, click the Equation button in the Symbols group in the Insert tab.

Write Subscript with Ink Equation

  • As a result, a context menu will appear.
  • Now, select Ink Equation.

  • Consequently, the Math Input Control box will pop up.
  • Now, using your mouse, you can write the equations in the input box.

  • Thus, we obtain our results.

How to write subscript in Excel output using ink equation


6. Format Cells in Excel to Add Subscript

You can change the appearance of your text using the Format cells options. Furthermore, you can add subscripts using the same tool. Follow the steps to do so.

Steps:

  • Select the required text that you want to convert.
  • After that, press Ctrl+1 to call the Format cells menu option.

Format Cells in Excel to Add Subscript

  • Later, tap Format cells in the menu.

  • As a result, the Format Cells menu will appear.
  • Next, check the Subscript option in the Effect group.
  • Finally, hit Ok to obtain your desired format.


7. Format Part of the Text as Subscript

Similarly, you can format part of the text as a subscript using the Format Cells feature. Therefore, follow the steps below.

Steps:

  • Above all, select the text part you wish to format.
  • Next, go to the Home tab and click the Font dropdown button.

Format Part of the Text as Subscript

  • As a result, a Format Cells box will appear.
  • Later, tap Subscript and press Ok.
  • Finally, the part of the text will appear as a subscript.


8. Select Symbol Command in Excel to Insert Subscript

We can insert subscripts to our texts using the Symbol button in the Symbols group. To do so, follow these procedures.

Steps:

  • Locate the Symbol in the Symbols group of the Insert tab.

Select Symbol Command in Excel to Insert Subscript

  • Subsequently, a Symbol dropbox will open up.
  • Now, select Superscripts and Subscripts in the Subset box.
  • Afterward, click the desired subscript text.
  • Finally, it will appear in the required cell.


9. Write Subscript Through Excel VBA

We can effectively write subscripts using Excel VBA. For instance, if you want to convert a long list of numeric values into subscripts, Excel VBA is a very effective way to do that. Moreover, you do not have to select every data separately. Excel VBA will convert all the numeric values into subscripts or any other formats you wish. Let’s see some procedures.

Steps:

  • First of all, press Alt+11 to open the Visual Basic
  • Afterward, click Insert and then Module to create a module.
  • Subsequently, a Module box will appear.

Write Subscript Through Excel VBA

  • Now, type the following VBA code into the module. You can also copy and paste it.
Sub ADD_SUBSCRIPT()
    Dim SelectedRange As Range
    Dim SelectedCell As Range
    Dim SelectedString As String
    Dim SelectedChar As String
    Dim i As Long
    Set SelectedRange = Selection
    Application.ScreenUpdating = False
    For Each SelectedCell In SelectedRange
        SelectedString = SelectedCell.Value
        For i = 1 To Len(SelectedString)
            SelectedChar = Mid(SelectedString, i, 1)
            If SelectedChar >= "0" And SelectedChar <= "9" Then
                SelectedCell.Characters(i, 1).Font.Subscript = True
            End If
        Next
    Next   
  Application.ScreenUpdating = True   
End Sub
  • Finally, hit Run.

  • Thus, your selected range will return the numeric values into subscripts.

How to write subscript output using Excel VBA


10. Insert Excel UNICHAR Function to Add Subscript

In this method, we will add subscripts using the UNICHAR function. The UNICHAR function returns the UNICODE characters when we provide a number at a given code point. Let’s see how it works.

Steps:

  • In cell D6, write the following formula,
=UNICHAR(8322)
  • As a result, 2 will appear as a subscript.
  • Here, the UNICHAR function takes 8322 as a number input and returns 2 as a subscript value.
  • Finally, hit Enter to obtain the result.

Insert Excel UNICHAR Function to Add Subscript


11. Copy and Paste to Add Subscripts

The previous procedures are great ways to add subscripts to our texts. However, copying these characters from a source and pasting them into your workbook is much easier to do. Let’s follow these easy procedures.

Steps:

  • First, copy the character you want in your text as a subscript.
  • After that, paste it into your texts.

Copy and Paste to Add Subscripts

  • As a result, we get your results.


Conclusion

In conclusion, we have discussed some easy ways to add subscripts in Excel here. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please leave any further queries or recommendations in the comment box below.


Related Articles

Yousuf Khan

Yousuf Khan

Hello! This is MD Yousuf Khan. I am a graduate & post-graduate in Information Technology from Jahangirnagar University, Bangladesh. Currently, I am writing articles for ExcelDemy. I am an independent, self-motivated person with enthusiasm to learn new things, and always try to do my best in any work assigned to me.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo