How To Do Subscript In Excel

To do subscript in Excel, you can use the formula =CHAR(8321) to convert the desired number into subscript text, and then format the cell accordingly. To use the CHAR formula to convert text to subscript in Excel.

In the world of spreadsheets, Excel is king. It offers a wide range of features and functions that allow users to manipulate and analyze data with ease. One such feature is the ability to format cells, numbers, and even text using subscript. Subscript is commonly used in mathematical and scientific equations, chemical formulas, and even in footnotes. In this blog post, we will dive into the world of subscripts and explore how to effectively use them in Excel. So, whether you’re a student, a researcher, or simply someone looking to improve their Excel skills, read on to learn how to do subscript in Excel and take your spreadsheet game to the next level.

How To Do Subscript In Excel: Step-by-Step


Step 1: Open Excel

To add subscripts in MS Excel, simply launch the software on your computer and open the desired worksheet. From there, you’ll be able to easily incorporate subscripts into your data for improved clarity and precision.

Next Step

Step 2: Input Data

In spreadsheet software, such as Microsoft Excel, you can enter subscript text by selecting the cell where you want the subscript and using the appropriate formatting options to display smaller characters below the regular text. This is useful for scientific formulas or chemical equations.

Next Step

Step 3: Select the characters

To subscript text in a cell, enter edit mode by double-clicking the cell. Then, simply click and drag your cursor to highlight the desired characters. This allows you to apply the subscript formatting to the selected text.

Next Step

Step 4: Open Font dialogue box

To access advanced formatting options in Excel, navigate to the “Home” tab, find the “Font” group, and click the small arrow in the corner to open the “Format Cells” dialogue box.

Next Step

Step 5: Apply Subscript

In the “Format Cells” window, under the ‘Font’ tab, you can find the ‘Subscript’ option under the ‘Effects’ section. Enable it by checking the checkbox and then click OK to apply the formatting.


Mastering the art of subscript in Excel can greatly enhance your spreadsheet skills and allow you to create more professional and visually appealing documents. By following the simple steps outlined in this blog post, you can easily add subscript text to your cells and equations, bringing clarity and precision to your data. With this newfound knowledge, you can now confidently create complex formulas, chemical equations, and mathematical notations with ease. So go ahead, experiment and unleash the full potential of Excel’s subscript feature to create stunning and impactful spreadsheets.

Table of Contents