How To Make Subscripts In MS Excel 2016

How To Make Subscripts In MS Excel 2016, superscripts and subscripts may already come in the formatting ribbon in Word and Powerpoint, yet they’re absent in Excel. This may make it a problem for those in academic fields, where subscripts and superscripts give additional context to different symbols.

The latest version of MS Excel, although has new features, still doesn’t have superscripts and subscripts readily available. Nothing to fear—these formatting features are available with a little tweaking.

This is why we’ve compiled a list of steps you can do when the need for creating super- and subscripts arises! Scroll down below to read more.

How to Make Subscripts in MS Excel 2016

    1). First, let’s start with the text you want to subscript. In the picture below, the word ‘sub’ will be              turned into a subscript.

subscripts and superscripts in excel 2016 1

    Covered by the black rectangle is the name of the MS user. Useful if you want to save your files        to OneDrive easily!

    2). Select the cell with the word that you want to subscript. Below, we can see xsub is in A1.

subscripts and superscripts in excel 2016 2


    3). Highlight the word to be subscripted. As mentioned in Step 1, the word we want to format to a            subscript is ‘sub’.

subscripts and superscripts in excel 2016 3


    4). Right click on the highlighted area. Below, you can see a list of commands appear.

subscripts and superscripts in excel 2016 4


    5). Left-click ‘Format Cells…’

subscripts and superscripts in excel 2016 5


    6).After clicking ‘Format Cells…’, a separate window will open.


7). Under Effects, click Subscript. Afterwards, click OK.

subscripts and superscripts in excel 2016 6


8). And you’re done! Now appreciate your new subscripted text!

subscripts and superscripts in excel 2016 7

  

How to Make Superscripts in MS Excel 2016

1). For making text in superscripts, we’ll use the word xsup, where ‘sup’ is the word to be superscripted. Select the cell that contains the word.

2).Repeat steps 3-6 from How to Make Subscripts in MS Excel 2016

3).Once the Format Cells window is open, click Superscript then OK.

subscripts and superscripts in excel 2016 8
subscripts and superscripts in excel 2016 9


4). And now you’ve got a superscript!

subscripts and superscripts in excel 2016 10

How to Make Subscripts and Superscripts In MS Excel 2016 in Graphs

Graphs are best made in MS Excel. However, sometimes certain variables require subscripts and superscripts to explain a point.

Take, for example, this picture below

subscripts and superscripts in excel 2016 11

How to make subscripts and superscripts in MS Excel 2016 The table headers for the data have their corresponding superscript and subscript, respectively. However, When that information is plotted in the graph, They lose their formatting.

Thankfully, we can format fonts in axis titles and chart titles as well!

1).  First, select the chart/graph you wish to perform the formatting changes. Then, click the title that        you want to perform the specific change.

subscripts and superscripts in excel 2016 12


2). Click the same object again, so that the rigid box that outlines the text is made up of dash lines.

subscripts and superscripts in excel 2016 13


3).Highlight the word you want to make format changes.


4).Right click on the word. A set of commands/options will be seen.


5). Select ‘Font…’

6). A Font window then opens up.


7). Click Superscript, then OK.


8).  And there you have it! The formatting you want!


9). To make subscripts, follow steps 1 to 7. Next, click Subscript then OK.


10). And now you have an axis title with a subscript!


11). You can apply this to chart titles as well…


How To Make Subscripts In MS Excel 2016 There are some exceptions…

So far, everything that we’ve formatted into subscripts and superscripts allows us to highlight and pick specific characters to perform format changes. However, there are certain elements that don’t allow us to do so.

The Legend element gives us limited options in what can be formatted to subscripts or superscripts.

             1). In this example, we’re using a bar graph with the same values we used in our first two                        examples regarding graphs. We can see the values of xsup and xsub are plotted and                         labeled on the bar graph, but the formatting doesn’t translate to the graph’s legend.


            2). Click the legends element of the chart you want to edit.

       

            3).Next, click the series that you want to edit the format. 

             4). And follow Step 9 of the How to Make Subscripts and Superscripts in Graphs section for                     creating subscripts, and Steps 1 to 7 for creating superscripts.

            5). And after applying the changes, you’ll see this change of format!

Noting from the above picture, the whole text has turned into a subscript. Creating subscripts and superscripts in the Legend will only get the whole series to become a subscript/supscript, as you can’t highlight certain specific characters.