Excel shortcuts

How to use the subscript shortcut in Excel

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!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.