[Solved:] Excel Subscript Not Working

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for a solution to Excel subscripts not working, then you are in the right place. While dealing with various numbers or digits we need to use subscript to represent values. In this article, we’ll try to discuss solutions for Excel subscript not working.


Excel Subscript Not Working (4 Possible Solutions)

Excel offers various ways for the solution to add subscripts. We just need to follow some simple steps in every method.

1. Using Format Cells

Using the Format Cells option is an easy way to activate a subscript. Suppose, in the following dataset, we need to add 4 as a subscript after WERT in cell C5.

excel subscript not working

Steps:

  • Firstly, select 4 > right-click on it > choose Format Cells.

Using Format Cells

  • Eventually, a Format Cells window will appear.
  • Secondly, select Subscript in the Effects box > click OK.

  • Consequently, 4 will be added as subscripts like this.

excel subscript not working

  • Lastly, follow the same procedures to fill other cells of Column C as Product ID with subscripts.


2. Applying Quick Access Toolbar

We can use the Quick Access Toolbar to activate subscript.

Steps:

  • Firstly, click the drop-down bar shown in the figure.
  • Secondly, choose More Commands.

Applying Quick Access Toolbar

  • Eventually, an Excel Options window will appear.
  • Thirdly, go to Quick Access Toolbar > select Subscript > click Add > again click Subscript > press OK.

excel subscript not working

  • Now, write the code of the Product ID. In this case, it is WERT4 where 4 should be a subscript.
  • Fourthly, mark 4 > click X2.

  • Eventually, 4 will turn into a subscript like this.

  • Similarly, do the same thing for other cells in Column C too, and finally, we’ll get the output like this.

excel subscript not working


3. Adding Subscript from Equation

We can add subscripts from the Equation feature manually. To do this, we need to follow the steps below.

Steps:

  • Firstly, go to Insert > click Symbol > select Equation.

Adding Subscript from Equation

  • Secondly, go to Equation > choose Structures > select Script > pick Subscripts box from the options.

excel subscript not working

  • Eventually, a box will appear like this.

  • Now, put 4 in the subscript position inside the box and WERT in the normal position.

  • Fourthly, place the box inside the C5 cell by sliding it.

excel subscript not working

  • Lastly, click outside of the box anywhere inside the sheet.
  • Eventually, the Product ID with a subscript in the C5 cell will be like this.

Read More: [Fixed!] Excel Superscript Not Working


4. Using Ink Equation

We can also use the Ink Equation to add subscripts. The steps below need to be followed.

Steps:

  • Firstly, go to Insert > choose Symbol > select Equation > pick Ink Equation.

Using Ink Equation

  • Eventually, a Math Input Control window will appear like this.

excel subscript not working

  • Secondly, click Write.
  • Thirdly, write manually WERT and 4 as subscript > click Insert.

excel subscript not working

  • Eventually, the writing box will appear like this.

  • Lastly, click outside the box, and finally, the subscript will be added like this.


Download Practice Workbook


Back to Learn Excel > Formatting Text > Subscript and Superscript


Conclusion

That’s all about today’s session. These are the ways of solving Excel subscripts if not working. We strongly believe this article would be highly beneficial for you.


Related Articles


<< Go Back to Subscript and Superscript | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo