Print worksheets and workbooks

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Take this course to learn all about printing worksheets and workbooks in Excel. From printing tables, multiple workbooks, multiple worksheets, specific cells or ranges of cells, headings, gridlines, formulas, and more. Also learn how to change print settings, and save time and paper by previewing what will print before you print it.

Inside this course:

Print worksheets and workbooks (1:09)
Print Excel worksheets and workbooks one at a time, or several at one time. You can also print a partial worksheet, such as an Excel table.

More print options (6:16)
Use print preview to change many default print settings and see what you’ll print. Also select a specific range of cells to print, and print a table in a worksheet.

Print a worksheet on a specific number of pages (4:40)
You want to print a worksheet on a set number of pages. There are several ways to do this without shrinking the worksheet, possibly making it hard to read.

Print headings, gridlines, formulas, and more (4:52)
Print gridlines and, for multiple page worksheets, print row or column headers or labels (also called print titles) in the first row or multiple rows on every page.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Applies To: Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language