How to set the table header for paging printing in Excel
- 藏色散人Original
- 2020-04-10 11:07:2929359browse
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!
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
Previous article：How to filter the same data in two tables in excelNext article：How to filter the same data in two tables in excel