Enter text in cell with subscript or superscript in Excel

For example, I want to enter the following information as is in an Excel cell - how can I do that?

excel enter text in cell with subscript or superscript

To do it in Excel, here is the answer:

a) Enter the text required continuously as it is in cell as shown below.

excel enter text in cell with subscript or superscript

b) Select the term that has to change to subscript (d next to h in this case), right click and select Format cells.

excel enter text in cell with subscript or superscript

c) In the Format Cells dialog box that shows up, click on "Subscript" under Effects in "Font" tab. Click OK.

excel enter text in cell with subscript or superscript

d) Similarly, select the term that has to change to superscript (0.5 in this case), right click and select Format cells.

excel enter text in cell with subscript or superscript

e) In the Format Cells dialog box that shows up, click on "Superscript" under Effects in "Font" tab. Click OK.

excel enter text in cell with subscript or superscript

f) The text changes to required format with subscript and superscript as shown below.

excel enter text in cell with subscript or superscript

 

You can find similar Excel Questions and Answer hereunder

1) How can I have text autocomplete based on values previously entered in Column?

2) How to see to which cells a cell is connected or used by. How to see the precedents of a cell

3) How do I enter a formula in a cell using VBA (using Relative Reference)?

4) How can I enter multiple lines of data in a cell?

5) How can I enter a cent symbol in a cell?

6) How can I enter a picture in a cell?

7) How do I change the rating numbers to rating labels?

8) Here an explanation about text box and how to control text boxes in Excel VBA

9) How can I set the fill color, font color and set number format of cell to date?

10) Highlight row of selected cell in Excel

 

Here the previous and next chapter