How to format text as subscript in Excel?

While Microsoft Word provides a straightforward subscript button on its toolbar, Excel requires a few more steps to achieve the same formatting. This can make the task of formatting text as subscript in Excel seem a bit more complex. However, with the right approach, you can easily apply subscript formatting to enhance your documents, especially when working with chemical formulas, mathematical expressions, or referencing notes. This tutorial will explain how to format text as subscripts in Microsoft Excel efficiently.

• Format text as subscript with formatting cells
• Format text as subscript with Kutools for Excel

Format text as subscript with formatting cells

If you want to format text as subscript in Microsoft Excel, please do as follows:

• Step 1: Select a cell, range, text or characters in a cell;
• Step 2: Click the launcher button  in the Font group under Home tab to open the Format Cells dialog box;
• Step 3: Go to the Effects section, and check the Subscript option;
• Step 4: Click OK. See screenshot.

You can also open the Format Cells dialog box with holding down Ctrl + Shift + F keys, or open it with clicking Format Cells command item from context menu.

Format text as subscript with Kutools for Excel

Kutools for Excel enhances the functionality of Excel by adding a variety of useful features, including an easy-to-use Superscript/Subscript tool. This tool simplifies the process of formatting text as subscript in Excel, a task that can be cumbersome using Excel's native functions. With Kutools, not only can you quickly apply subscript formatting, but you also gain the ability to adjust additional formatting styles for subscript characters.

Step 1: Select one cell, and click Kutools > Format > Superscript / Subscript.

Step 2: Select the characters that you need to format as subscript, and check the Subscript option, see screenshot;

Step 3: If you want to format other characters as subscript, redo Step 2, and click OK to save settings.

This tool will format characters as subscripts in one cell one by one. And you can format many characters in selected cell as subscript without closing the dialog box. In addition, you can also apply other format style: bold, italic, upper case, font size, and color, etc.

Related Article

• How to format text as superscripts in Excel?