Home>Article>Topics> How to set the table header for paging printing in Excel

How to set the table header for paging printing in Excel

藏色散人
藏色散人 Original
2020-04-10 11:07:29 29250browse

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"

How to set the table header for paging printing in Excel

Click on the file

How to set the table header for paging printing in Excel

Open page settings

How to set the table header for paging printing in Excel

Select the worksheet form

How to set the table header for paging printing in Excel

Click the top title row option box Icon

How to set the table header for paging printing in Excel

#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

How to set the table header for paging printing in Excel

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

How to set the table header for paging printing in Excel

Click OK, OK setting is successful

How to set the table header for paging printing in Excel

Print and preview, there is a header on page 2

How to set the table header for paging printing in Excel

How to set the table header for paging printing in Excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn