Excel Print At Each Page Break How To Make That

Now, since most such documents have a header row (which is the first row) it is always good to make it non-scrollable.

But, when you wish to print the document or convert it to PDF, for example, the header row prints only once.

Excel Print At Each Page Break How To Make That

Whereas with data on multiple pages you would want the first row or column to appear at the top row of each page, right We will learn how to make that happen, today.

Cool Tip: In case you are looking to print your company name, address, logo and akin on every page then I suggest that you add a page header and configure the settings as described in our detailed guide.

Setup Printing of Top Row on Every Excel Page This setup applies to Office 2007 and later versions.

I am not very sure about earlier ones but you may want to check it out.

Step 1: On your workbook, select the desired sheet and navigate to Page Layout tab on the ribbon.

Then click on the icon for Page Titles placed under Page Setup section.

Step 3: To setup printing of top row on each page click on the button placed against Rows to repeat at top text box.

Step 4: That will take you to the Excel sheet along with a dialog box.

Click on row number 1 (on the sheet) and hit the dialog box right end button again.

Generally, you would want the top row and at rare circumstances the leftmost column.

Step 5: Back on the Page Setup modal window, you will see the text boxes populated with the rowcolumn values to repeat on each page.

You can go for a Print Preview, Print the contents or save the settings by hitting on Ok.

Note that the settings are sheet specific and do not apply to the entire workbook.

Conclusion I hope this solves your problem of keeping the header intact on each page of your document whether you print a hard copy or a soft copy (PDF, XPS, etc.) of the document.

There are many more interesting print settings associated with Excel.

Tell us if you need something very specific, we will try to help you out.

Did You Know The word Robot is derived from Robota, meaning forced labor.

Excel For Mac Print At Each Page Break