If you work with large amounts of data in Microsoft Excel, you may find yourself in need of a quick way to enter subscript characters. For example, if you're working with chemical formulas, you'll need to be able to enter subscript characters for the various elements. Or, if you're working with mathematical equations, you'll need to be able to enter subscript characters for the various variables. Luckily, there's a shortcut that you can use to quickly enter subscript characters in Excel.
To use the subscript shortcut, simply hold down the CTRL key while pressing the equal sign (=). Then, type in the character that you want to be subscripted. For example, to enter the chemical formula for water, you would type "H2O" (without the quotation marks).
You can also use the subscript shortcut to enter mathematical equations. For example, if you wanted to enter the equation for the area of a circle, you would type "A=r2" (without the quotation marks).
So, next time you need to enter a subscript character in Excel, don't reach for the mouse. Just use the CTRL+equal sign shortcut!