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.
Error while processing your submission.
There was an error while trying to process your submission. We are sincerely sorry for the inconvenience.
Please reach out to one of our Admission Counselors and they can answer any questions you have at 1-800-756-7920 (option 1). The Admissions office is open Monday through Thursday 8:00 a.m. to 8:00 p.m. (CST) and Fridays from 8:00 a.m. to 5:00 p.m. (CST).
Congratulations on taking your first step towards earning your degree!
At Bellevue University, our passion is to help you get started and support you all along the way. In fact, we’ve found that many students have benefited from our complimentary “Smarter Measure” Self-Assessment which will help you prepare for success. Again, this is a free service.
Your User Name: ready
Your Password: ready
Just click here to start. Smarter Measure
Thanks again. We look forward to working with you!