Bellevue University Tops U.S. News Rankings

Fractions in a cell and print row and column headers

Fractions in a cell

You want to have a fraction in a cell but each time you enter it (1/2, 3/4, 5/8, etc.) it formats as a date (2-Jan, 4-Mar, 8-May). Annoying!


  • Select the cell.
  • On the Home tab, Number group, choose "Fraction" then type your number.

Print row and column headers

Excel doesn't normally print row and column headings on each printed page. But you want it to!


  • Click the worksheet.
  • On the Ribbon click the Page Layout tab.
  • In the Sheet Options group, under Headings, select the Print check box.

Thanks for your interest in Bellevue University.

When you click the submit button below, our staff will contact you within 48 hours to get you the information you need and answer any questions.

Yes No