How to set the table header for paging printing in Excel

How to set the header in excel paging printing

To set the header in the red box as follows Page header

Recommended: "Excel Tutorial"

Click on the file

Open page settings

Select the worksheet form

Click the top title row option box Icon

#Move the mouse to the 1st row, hold down the left mouse button and drag to the 3rd row to select the header to be printed on each page

Click Page Settings - the icon after the top title row option

Click OK, OK setting is successful

Print and preview, there is a header on page 2

The above is the detailed content of How to set the table header for paging printing in Excel. For more information, please follow other related articles on the PHP Chinese website!