When working in Excel, you may wonder how to put m² in Excel cells so that it looks like metres squared instead of just m2. It is surprisingly easy.
Below what the text looks like normally and with the superscript 2 (the word for little character next to a big character).
To achieve this you:
- highlight the character you want to change (click in the cell and highlight the 2 in the example below)
- click on the Font Expander (or you can push CTRL 1 for the shortcut)
- Choose the Superscript option and click OK.
Now instead of m2 you will get m².
You can use this for a number of formatting options.
As shown below we can change the format of individual characters so that:
- the font size is different,
- change characaters colours for emphasis,
- make some characters bold or italic
- use a subscript for things like references or notes in Excel
- strikethrough characters.
Related: If you are interested in making your Excel spreadsheets more visually appealing perhaps look at our Excel Dashboards course.