You must have seen the subscripted text or a number such as Log represented with a base or the valency in chemistry.
Subscript is the process of putting a smaller version of any letter or symbol lowered from the normal level of text input. For Example H2O. 2 is in the subscript format.
The most common example of a subscript is found in the Mathematics such as showing the LOG BASE or in Chemistry while writing the chemical formulas etc.
We also need this while showing the NUMBER BASE whether its binary or octal or hexadecimal etc.
In this article , we’ll learn to apply SUBSCRIPT FORMAT in various ways in Excel.
SUBSCRIPT is mostly needed while we are working with Mathematics or Chemistry.
We require them frequently while working with chemical formulae or Logarithms .
H2O is the chemical formula of water.
Log210 and Log10100 are the logarithm expressions with different base.
We can use many ways to SUBSCRIPT the text in Excel.
The ways available are :
Let us discuss all the ways one by one in detail.
We ‘ll take a few examples to learn how we can put the ending text to SUBSCRIPT format in excel.
The following picture shows the current situation.
We’ll use the subscripting steps on the SUBSCRIPTED TEXT column.
This section deals with the techniques to SUBSCRIPT the text in Excel.
STEPS TO SUBSCRIPT THE TEXT IN EXCEL.
We can also subscript our text directly from the EXCEL RIBBON.
STEPS TO SUBSCRIPT USING THE OPTION PRESENT IN EXCEL RIBBON.
The fastest way of operation in any software is still the use of KEYBOARD SHORTCUTS.
THERE IS NO DIRECT SHORTCUT FOR SUBSCRIPT TEXTING TEXT IN EXCEL. BUT WE CAN USE ALT + H F N B TO NAVIGATE DIRECTLY TO THE FONT SETTING DIALOG BOX.
Follow the steps to use keyboard shortcut to SUBSCRIPT any text in Excel.
Did you notice that we didn’t do the Third example in our picture which is 67 raised to power 34 yet in detail.
If you try this example, you would find that excel would convert it to 6734.
So follow the steps to avoid this problem.
Select the cell containing the Numbers.
We need to convert the Format to the TEXT so that we can convert the number to subscript .
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE