EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Subscript in Excel
 

Subscript in Excel

Udiksha Sable
Article byUdiksha Sable
Madhuri Thakur
Reviewed byMadhuri Thakur

What is Subscript in Excel?

Subscript in Excel is a formatting option that lets you display a character or a group of characters slightly below the regular text line in a smaller font size. For instance, you can display Oxygen’s chemical formula O2 as O2 by using subscript in Excel.

We often use subscripts in mathematical formulas, chemical formulas, etc. You can use them when you want to present numbers, symbols, or text in a smaller size at a lower position in comparison to the other text.

Table of Contents
  • What is Subscript in Excel?
  • Shortcut
  • How to do Subscript in Excel? (Stepwise Examples)
    • Using the Shortcut Method
    • Using the Format Text Option
    • Using Symbols
    • Using an Equation
    • Using Ink Equation
    • Using Kutools
  • How to Add Subscript to Quick Access Toolbar?
  • How to Add Subscript to Excel Ribbon?

Shortcut for Subscript in Excel

Shortcut for Windows:

 

 

  1. Select the character you want to format as a subscript (e.g., select 2 & 4 from H2SO4).
  2. Press “Ctrl + 1” to open the “Format Cells” dialog box.
  3. Press “Alt + B” to choose the “Subscript” option from the dialog box.
  4. Press “Enter” to convert the text into a subscript. As a result, the text will be H2SO4.

SUBSCRIPT IN EXCEL

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to do Subscript in Excel?

Example #1: Using the Shortcut Method

Let us use subscript to change the number 2 in this sentence to subscript: “H2O is the chemical formula for water.”

1. Select the character “2” for formatting, as seen below.

Example 1

2. Press “Ctrl+1” or “Ctrl+Shift+F” to open the Format Cells dialog box.

Example 1.2

3. Use the shortcut “Alt + B” to select ” Subscript “ in the dialog box

Example 1.3

4. Confirm your choice by pressing the “Enter” This applies the formatting and closes the dialog box.

Example 1.4

Example #2: Using the Format Text Option

Let us change “4” to subscript in the sentence: “The formula CH4 represents Methane.”

1. Select the number 4 in the cell.
2. Right-click and select “Format Cells,” and the “Format Cells” dialog box appears.

Example 2.1

3. In the “Font” tab under the “Effects” section, checkmark the “Subscript” box.
4. Click “OK”.

Example 2.2

Result:
The selected text or number will now appear as a subscript.

Example 2.3

Example #3: Using Symbols

The Insert Symbol feature in Excel also helps us to insert subscripts.

Let’s say we want to add a subscript 2 to correctly complete the following sentence: “The chemical symbol for oxygen is O”.

Final(Subscript with Symobol)

Follow the below steps to do it:

  1. Choose the cell and place your cursor where you want to insert the subscript
  2. Go to the Insert tab at the top of the Excel sheet
  3. Click the Symbol button in the Symbols group
  4. Open the Font dropdown list and select “(normal text)”
  5. Open the Subset dropdown list to select Superscripts and Subscripts
  6. Select the script character which you want to add as a subscript. For example, here, we will choose 2 as the subscript character
  7. Click the Insert button and close the dialog box.

Doing this will add the number as a subscript in your desired cell.

Example #4: Adding Subscript with an Equation

Excel has an equation feature that allows you to easily add equations with many subscripts or superscripts.

Let us write the equation “6CO2 + 6H2O → C6H12O6 + 6O2” using the feature.

1 Final (Subscript with Equation)

Follow these steps to work with the Equation Editor:

  1. On the Excel ribbon, open the Insert
  2. Click on the Equation button in the Symbols (Note that you must click on the Equation button and not on the dropdown menu near it).
  3. In the Equation tab, click the Script button in the Structures
  4. Choose Subscript. Two boxes will appear.
  5. Use the left arrow on your keyboard to move your cursor to the larger box and type “6CO“.
  6. For subscript “2“, move to the smaller box using the right arrow, then type “2“.
  7. For regular text, move right using the right arrow and type “+“.
  8. Repeat steps 3-7 for your complete equation.
Note: If you are using older versions of Excel, open the Equation tool, Design Tab after step 2, and then continue with step 3.

Example #5: Adding Subscript with Ink Equation

Final(Inkequation for subscript)

Note: This feature is only available in Excel 2016 and newer versions. However, you can add this by customizing the toolbar by importing the customization file.

Follow the below steps:

  1. Go to Insert
  2. Select Equation from the Symbols
  3. Select Ink Equation from the Tools group in the left corner. A Math Input Control dialog box will appear.
  4. Select the write tool from the list and start doodling in the Write math here
  5. You can check the preview section to see if the equation is correct. Once done, select the Insert option to close it.
  6. You will see the result displayed in the box.

Example #6: Adding Subscript multiple characters in cells using Kutools

Imagine you have several characters in a cell that you want to make smaller and lower. Kutools for Excel has a subscript tool that can do this easily. Instead of changing each character individually, this tool lets you select the characters you want and turns them into subscripts simultaneously.

Note: You have to get Kutools for Excel installed.

1. Click on the cell that contains the text you want to format.

Example 6.1

2. Go to the Excel ribbon and look for the Kutools

Example 6.2

Note: This tab will only be available if you have successfully installed the Kutools add-in.

3. Under the Editing group, select the Format dropdown list
4. Click on the Superscript/Subscript option (The wording might vary based on your Kutools version).

Example 6.3

5. A small dialog box or formatting window will open. You can use the two middle arrow buttons (< & >) or the two shift arrows (<< & >>) to view the next or previous part of the sentence.

Example 6.4

6. In the window that appears, do as follows:

    • Select the character you want to convert to a subscript
    • Select Subscript from the Char 36 You can see a preview of how your selected text looks like.
    • Once you have changed all the required characters to subscript, click the OK or Apply button to confirm.

Example 6.5

Result:

Example 6.6

How to Add Subscript in Excel’s Quick Access Toolbar?

1. Open Microsoft Excel.
2. Find the Quick Access Toolbar near the top-left corner, above the ribbon.
3. Find the small arrow or down-facing triangle icon at the end of the Toolbar.

How to Add Subscript-1

4. Click on the arrow to open a dropdown menu.

How to Add Subscript-2

5. Select More Commands. It opens a customization window.

How to Add Subscript-3

6. In the window, the left column lists available commands, and the right shows current quick access toolbar commands.

How to Add Subscript-4

7. Find the Subscript or Format as Subscript command, and click on it to select it.

How to Add Subscript-5

8. Click the Add button between the two columns to add the command to the Quick Access Toolbar.

How to Add Subscript-6

9. You can use the up and down arrows on the right side of the customization window to rearrange the commands.

How to Add Subscript-7

10. Once satisfied, click “OK” to close the customization window.

How to Add Subscript-8

Result:
You should now see the subscript icon on the Quick Access Toolbar.

How to Add Subscript-9

Note: Remember that the steps vary slightly based on the version of Microsoft Office you are using.

How to Add Subscript to Excel Ribbon?

1. Right-click on the Excel ribbon (top menu) and select Customize the Ribbon from the context menu.

Add Subscript to Excel Ribbon-1

2. An Excel Options dialog box opens. Navigate to the Customize the Ribbon section on the left.

Add Subscript to Excel Ribbon-2

3. In the right pane, you will see a list of tabs available on the ribbon. Choose the specific tab where you want the subscript button to be.

Add Subscript to Excel Ribbon-3

4. Click on the New Group button at the bottom.

Add Subscript to Excel Ribbon-4

5. Click on the Rename button and add a meaningful name.

Add Subscript to Excel Ribbon-5

6. In the left-hand dropdown list of “Choose commands from, ” scroll down, find “Subscript,” and select it.

Add Subscript to Excel Ribbon-6

7. Click the “Add” button to move the command to the new group.

Add Subscript to Excel Ribbon-7

8. Click OK

Add Subscript to Excel Ribbon-8

Result:
You have successfully added the subscript button to the Excel ribbon.

Add Subscript to Excel Ribbon-9

Frequently Asked Questions (FAQs)

Q1. Can we apply subscripts to all cell formats in Excel?
Answer: Yes, you can apply subscript formatting to any format cell in Excel, including numbers or non-textual content. Moreover, you can use subscripts for text within and for the entire cell.

Q2. What are Alt codes for subscripts in Excel?
Answer: You can use Alt codes to input subscript characters in Excel using your keyboard’s numeric keypad. For instance, the Alt code for subscript 2 is Alt + 8322. To use them, press and hold the “Alt” key, enter the Alt code, and release the “Alt” key. This will insert the corresponding subscript character at the cursor’s position.

However, remember that the availability of these characters can depend on your operating system and font settings. In that case, you can use the following formula =UNICHAR(8322). This will add subscript 2 to the cell.

Recommended Articles

This comprehensive article on Subscript in Excel shows you different ways to write and insert subscript in Excel. We have also included steps to add subscript in the quick-access toolbar and the Excel ribbon. Refer to the following articles for more Excel-related knowledge.

  1. Superscript in Excel
  2. Excel Formulas
  3. Excel Match Function
  4. VBA Subscript out of Range

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Subscript Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

EDUCBA

Download Subscript Excel Template

EDUCBA

डाउनलोड Subscript Excel Template

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Limited Time Offer! - ENROLL NOW