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 excelWant to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.