

Formatting an Excel table for printing it out is usually troublesome. You have to adapt the print area, select rows and columns to repeat and set the headers and footers. The problem: In most cases, you can’t apply the print layout to several sheets at the same time as it easily overrides your previous formatting. In this Excel Tip, we’ll have a look at setting headers and footers.
Please also take a look at our comprehensive guide for printing Excel sheets.
Steps for changing printout headers in footers in Excel
The conventional method is setting the headers and footers manually. Therefore, follow these steps (the numbers are corresponding with the image on the right hand side):
Instead of preparing each sheet separately, you can mark all worksheets and format them at once. Unfortunately, there are two major disadvantages with this method:
Comfortably change headers and footers with Professor Excel Tools – all other print preferences will remain!
For solving the disadvantages of the first method, the Excel add-in ‘Professor Excel Tools’ comes with a function for setting and updating comfortably. You can update or set printout headers and footers for all worksheets (or just selected worksheets) at the same time. Also, the last settings are saved.
To conclude: With only two clicks you can set headers and footers for the complete workbook in your own style.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.