Page 1 of 23PREVNEXT

So that's how! Printing options in Excel

Excel worksheet and printer
See how to get the results you want when you print in Microsoft Office Excel.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use print preview to see what you're about to print.
  • Fit more columns onto one page when you print.
  • Add repeating column or row titles to each printed page.
  • Add page numbers, the date, or text in headers and footers.

You're printing a worksheet for an important meeting. You need to present a one-page report, but the last column spills over onto a second page. Is there a way to fit all your data onto one page?

Yes, there is. And this is the place to learn how.

You'll also find handy tips here on how to help readers get the most out of worksheets that really have to be printed on more than one page. Repeating column titles on each page make clear what the data is about. And page numbers in the header or footer prevent any questions about page order.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.

Page 1 of 23PREVNEXT