How to Print Header on Each Page Excel

If you’re working on a lengthy Excel file that spans over multiple pages, it can be helpful to have key information repeating on every printed page. Fortunately, Microsoft Excel offers users the option to print headers on each page, making it easy to keep headers, titles, and other key information visible throughout your document. This feature is incredibly useful when you need to present your data in a clear format or print your Excel document for review by others. In this blog post, we’ll explore how to print header on each page in Excel, step by step.

Enable Print Area

Before we print headers on each page, we need to ensure that the print area is enabled. Here’s how to enable it:

1. Select the page(s) that you would like to print.
2. Go to the Page Layout tab in the Excel Ribbon.
3. Click on the Print Area button.
4. Click on Set Print Area.
5. The print area for the selected page(s) should be now set.

Add Header to the Sheet

Now, let’s add a header to the sheet. Here’s what you need to do:

1. Select the Insert tab in the Excel Ribbon.
2. Click on Header & Footer.
3. Enter the desired header information into the Header box.
4. Click on Close Header and Footer.

Print Header on Each Page

We’ve now set the print area and added a header to the sheet. Here’s how to print the header on each page:

1. Select the Page Layout tab in the Excel Ribbon.
2. Click on Print Titles.
3. In the Page Setup dialog box, select the Sheet tab.
4. Under Print titles, click on the Rows to repeat at top.
5. Select the row with the header information.
6. Click on OK.

That’s it, the header will now be printed on each page when you print the sheet!

Additional Tips:

If your header doesn’t appear on every printed page, try these additional tips:

1. Ensure that the “Scale to Fit” option is turned off in the Page Layout tab.
2. Make sure that the “Fit All Columns on One Page” option in the Page Setup dialog box is unselected.
3. If the header is still not printing on each page, try repeating the process and re-selecting the print area by going to Page Layout>Print Area>Clear Print Area, and then start again at Step 1.

Additional Tips for Customizing Headers

Headers allow you to add important information to your spreadsheet that can help you quickly identify each page. Here are some additional tips that can help you customize your headers even further:

1. Add page numbers – You can add page numbers to the header, making it easier to keep track of where you are in your document. Simply insert “&[Page]” into the Header field where you want the page number to appear.
2. Add dates and times – If you need to keep track of when each page was printed, you can add the date and time to your header by inserting “&[Date]” or “&[Time]” into the Header field.
3. Use the Header/Footer tool – Excel has a handy Header/Footer tool that allows you to quickly insert pre-made headers and footers. To access this tool, simply click on Insert > Header & Footer and select one of the pre-designed options.

Why Print Headers on Each Page is Useful?

Printing headers on each page can help you keep your Excel documents more organized and professional-looking, especially when you’re dealing with multi-page spreadsheets. With headers, you can easily label each page with important information like the document’s title, author name, date of creation, etc., and ensure that this information is visible on each page when printed. Moreover, headers can also save you considerable time and energy by eliminating the manual task of copying and pasting titles on each page. Instead, you can have Excel do the work for you, allowing you to focus on other crucial tasks.

In Conclusion

Printing headers on each page in Excel is a simple process that doesn’t take much time at all, but it can really make a difference in how your document looks and is received. By following the steps outlined in this post, you can quickly add headers to your spreadsheets and ensure that they appear on each page when printed. Whether you’re working on a long report, financial statements, or any other type of multi-page Excel document, headers are an easy way to keep them organized and professional-looking.

FAQ

Here are the answers to some commonly asked questions about printing headers on each page in Excel:

Can I print different headers on the first page of my document?

Yes, you can print a different header on the first page of your document than on the subsequent pages. To do so, select the Page Layout tab, click on Print Titles, and then click on the Header/Footer tab in the Page Setup dialog box. Under Header, select “Different First Page.”

Can I change the font of the header?

Yes, you can change the font of the header by selecting the header, going to the Home tab, and choosing a font from the Formatting toolbar.

Can I add images to my header?

Yes, you can add images to your header by selecting the Insert tab, clicking on Pictures, and then selecting the image you want to add. You can then format the image as needed by selecting it and using the Picture Tools tab.

Can I use headers with Excel templates?

Yes, you can use headers with Excel templates. You can either add headers to a template directly or add headers to individual worksheets created from the template.

Do I need to repeat the header manually on each page?

No, you don’t need to repeat the header manually on each page. By following the steps outlined in this blog post and selecting the “Rows to repeat at top” option, Excel will automatically repeat the header on each page when printed.