enter text in cell with subscript or superscript in Excel

Q67. In Excel, how can I enter a text in a cell with subscript and superscript?

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 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 excel 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 excel excel 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 excel excel excel 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 excel excel excel excel excel enter text in cell with subscript or superscript

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

excel excel excel excel excel excel excel enter text in cell with subscript or superscript

 

You can find similar Excel Questions and Answer hereunder

1) How can I quickly navigate to a frequently used field in a voluminous worbook?

2) How can I enter an Engineering or Mathematical equation like Binomial Theorem Equation in Excel?

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

4) How can I get input from user through a prompt and assign user's input to a cell?

5) how do you enter multiple line in a cell in Excel

6) Concatenate number with text but keeping in number format in Excel

7) How can I add and link a Chart Title to a cell value?

8) Vlookup to return multiple values in same cell in Excel

9) How can I identify all cells with Data Validation in my WorkSheet?

10) How to read a value from a cell in vba in Excel

11) Remove the apostrophe cell text values in Excel

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

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

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

15) How can I activate a routine when there is a change in value of a cell?