How to put m2 in excel

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).

how to put m2 in excel

To achieve this you:

  1. highlight the character you want to change (click in the cell and highlight the 2 in the example below)
  2. click on the Font Expander (or you can push CTRL 1 for the shortcut)
  3. Choose the Superscript option and click OK.

how to put m2 in excel

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.

how to put m2 in excel

If you are interested in making your Excel spreadsheets more visually appealing perhaps look at our Dashboards course.