How to write a fraction in Microsoft Excel?

  • In Excel go to Insert → Object.
  • From the list select "Microsoft Equation 3.0".
  • Select the equation that suits your needs. In this case:

enter image description here

  • Type 2, press TAB key to move the cursor and then 3.

This is my result:

enter image description here


If you don't want to mess with the equation editor, and all you are looking to do is display the fraction, you can simply use regular cells with a border between the upper and lower cell. Then resize the cells to format it the way you like.

enter image description here


Inside of a text box (Insert→Text Box), but not inside of a cell unfortunately, you can use Alt+= (or "New Equation" on the insert tab). This lets you freely type an equation (or use the ribbon's editor); typing x/y will automatically reformat it to a fraction, or you can manually insert a fraction and type into it.

Equation editor

Equation in a text box

I recommend this over Insert→Object because this type of equation uses a newer, cleaner editor (and you don't need to wait for the objects list to load). Neither option can be used within a cell, so this one is preferable.

Tags:

Microsoft Excel

Recent Posts