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.
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.
- First, select the text that you want to convert into a subscript.
- 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.
- 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.
- 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.
- To demonstrate, right-click anywhere on Excel Ribbon.
- Consequently, a context option menu will open.
- Here, click Customize the Ribbon option.
- 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.
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.
- In the Insert tab, click the Equation button located under the Symbols group.
- 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.
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.
- Firstly, click the Equation button in the Symbols group in the Insert tab.
- 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.
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.
- Select the required text that you want to convert.
- After that, press Ctrl+1 to call the Format cells menu option.
- 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.
- Above all, select the text part you wish to format.
- Next, go to the Home tab and click the Font dropdown button.
- 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.
- Locate the Symbol in the Symbols group of the Insert tab.
- 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.
- 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.
- 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.
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.
- In cell D6, write the following formula,
- 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.
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.
- First, copy the character you want in your text as a subscript.
- After that, paste it into your texts.
- As a result, we get your results.
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.