How to set Excel table header to be included on every page?

When printing an excel table, except for the first page, other pages have no headers. How to solve this problem? Let’s learn together!

How to set Excel table header to have

#Step 1:

First, we find [Print Title] under [Page Layout] and click to enter.

Step 2:

Find the [Top Title Row] in the pop-up [Page Setup] dialog box. After finding it, Click that little arrow button in the back.

Step 3:

After clicking the small arrow button, you will return to the EXCEL table interface and a floating dialog box will appear. . At this time, we only need to use the mouse to click on the table header that needs to be retained, and the rows to be retained will be prompted in the subsequent floating dialog box.

Step 4:

After selecting, we click the small arrow behind the floating dialog box. Just go back to the page setting interface. Let's look at the red box in the picture. Our reserved row is still there, so we can click OK.

After clicking OK, all steps are completed. We press CTRL P to enter the printing page. Check the second page again and you will see the header. Isn't it very simple? After setting it like this, no matter how many pages your EXCEL has, it will display the header on the first row, making it much easier to view the data in the future.

#Have you learned this little skill of adding headers to each page?

For more excel related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of How to set Excel table header to be included on every page?. For more information, please follow other related articles on the PHP Chinese website!