Printing Workbooks

Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.

To insert a break:

Click Print Preview to confirm that the break appears in the correct place in your spreadsheet.

To use the Print Titles command:

This is an important command to be familiar with if you intend to print your worksheets. It allows you to select specific rows and/or columns that will be repeated on each printed sheet. Imagine how difficult it would be to read page 48 of a printed spreadsheet if the column and row headings only appeared on the first page.

Print Tiles
Print Tiles

To print from the Microsoft Office button:


You can select Quick Print to bypass the Print dialog box.