Print worksheets and workbooks

Print worksheets and workbooks

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. Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive.

Applies to:
File Size:

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.