Ask a Teacher

1.Start the Microsoft Excel program.

2.Open the document you wish to add the fractions to by clicking "Open" on the toolbar. Select "Open" from the drop-down list. Select the file from the list.

3.Select the box, or cell, where you want to display the fraction. If you want to display fractions in multiple cells, highlight all of the cells.

4.Right-click on the cell and select the "Format Cells" option. Another alternative is to click on "Format" in the toolbar at the top and then select "Cells" from the drop-down menu.

5.Pick the "Numbers" tab. A list of categories is displayed. Select "Fraction" from the category list.

6.Select the type of fraction you want to display. Click "OK" to format the cell and close the display.

7.Type the fraction into the cell. For example, type "1/2" without any spaces. Excel automatically reduces fractions; if you enter 4/8, it changes to 1/2.

8.Input a whole number and a fraction in the same cell by typing the whole number, a space and then the fraction.