Blue Flower

Superscript and Subscript in Excel

How to write H2O, m2, m3, Mark for a Footnote in Excel

In this tutorial and in this example I will show how we can write in Excel items: H2O, m2, m3, CH4,  a Mark for a Footnote

In Excel cell you type the text that contains any subscript and superscript tags. Double-click the cell you select the number to convert as subscript or superscript. While the number selected, right-click the selection, and the pop-up menu or the shortcut menu, you select Format Cells.

How to write H2O, m2, m3, footnote in Excel

 

In a new dialog box, you enable the option for Superscript and if you want to create a number as Subscript enable the option below.

Custom Format Cells and Enable Superscript in Excel

All, I explained above looks like as shown below. (examples m2 = square meter, m3 = cubic meter, H2O = formula for water chemistry).

How to write text in Excel with Superscript and Subscript

Display a Measurement Unit Beside the Value by Custom Format Cells (1750 m2, 120 m3, 7 kg)

If you you need to form a format cell that is not standard form then you do remodeling through custom formatting for certain representations of design. eg: design display the number value in 1750 as a unit of measurement m2 or displaying units cubic meter.

Custom format cell should look like this: 0" m2" or 0" m3" or 0" kg".

Custom Format Cells in Excel and set measurement units