Professor Excel
print, excel, sheets, worksheets, printout, page, layout, guide

Print Excel Sheets: No More Trouble When Printing

It’s a nightmare: Printing Excel sheets. You permanently feel like Excel hates you when you want to print an Excel sheet. That said, let’s take a look at the basics (like defining the print range) as well as advanced topics (like changing headers and footers on several sheets simultaneously). 


How to Repeat Rows and Columns on Printouts

When you print a large table, you can select rows or columns which you want to repeat on each page. This way, the data is easier to read as the heading will be printed on each page.

How to Set Headers and Footers for Printouts

Formatting an Excel table for printing is usually troublesome. You have to adapt the print area, select rows and columns to repeat and set the header and footer. In this Excel Tip, we’ll have a look at setting headers and footers.